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.
In response to
pgsql-jdbc by date
|Next:||From: Dave Cramer||Date: 2004-02-13 18:53:14|
|Subject: Re: Serial key|
|Previous:||From: Kris Jurka||Date: 2004-02-13 18:33:24|
|Subject: Re: Startup message issues|