Tatsuo Ishii <is...@postgresql.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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
