Tatsuo Ishii <ishii(at)postgresql(dot)org> writes:
>> Sorry, I'm not real familiar with pgpool, but have you thought about
>> using an advisory lock on the target table, instead of a "real" lock
>> (SELECT ... FOR UPDATE / LOCK table)?
> Problem with the advisory lock is, it will not work if the target
> table is empty.
(a) why not? You could surely use the table OID as a key for the
advisory lock.
(b) advisory lock on the sequence might be better anyway.
regards, tom lane