On Fri, 13 Feb 2004, John Sidney-Woollett wrote:
> Alternatively, if you could use a sequence object for the primary key
> value (instead of a serial column), and you switched autocommit off, you
> should be able to determine the last allocated PK id AFTER creating the
> record by querying the currval on the sequence.
>
autocommit has nothing to do with this, sequence state via currval is
session specific, not transaction specific.
Kris Jurka