Kris Jurka wrote:
> On Thu, 18 Oct 2007, Michael Schmidt wrote:
>> Also, from my read of the documentation and experience, you have to
>> call nextval before you can call currval in the transaction.
> Right, but the insert should trigger the default on the serial column to
> call nextval behind the scenes.
> Kris Jurka
Exactly, because nextval is the default for the sequence. However, if
you do a transaction in which you don't do an insert, then currval won't
In response to
pgsql-jdbc by date
|Next:||From: Oliver Jowett||Date: 2007-10-18 20:59:57|
|Subject: Re: [JDBC] Re: 'on insert do instead' rule with a where clause
responds 'INSERT 0 0'|
|Previous:||From: Kris Jurka||Date: 2007-10-18 20:18:42|
|Subject: Re: Fw: postgresql experts please help|