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
be available.
Michael Schmidt