Re: Any idea for serializing INSERTING SERIAL column?

Tatsuo Ishii <ishii@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