Mon Jul 17 08:02:52 PDT 2006
- Previous message: [Slony1-general] Possible Bad Locking Situation...
- Next message: [Slony1-general] Possible Bad Locking Situation...
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> This is still probably *somewhat* susceptible to race conditions, but > it seems to be a "safening action" to me... Wouldn't it be feasible to use a form of "LOCK ... NOWAIT" to lock first the truncated tables in the proper mode, and then only truncate if the lock succeeded, otherwise issue the warning ? That would probably eliminate the race condition. OTOH this would only work for postgres 8.x and newer. Cheers, Csaba.
- Previous message: [Slony1-general] Possible Bad Locking Situation...
- Next message: [Slony1-general] Possible Bad Locking Situation...
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list