Skip site navigation (1) Skip section navigation (2)

Re: Fw: postgresql experts please help

From: Michael Schmidt <MichaelMSchmidt(at)msn(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>, Andrei Ilitchev <andrei(dot)ilitchev(at)oracle(dot)com>, pgsql-jdbc(at)postgresql(dot)org, Marina Vatkina <Marina(dot)Vatkina(at)Sun(dot)COM>
Subject: Re: Fw: postgresql experts please help
Date: 2007-10-18 20:20:06
Message-ID: BAYC1-PASMTP06B82BA1B0737436579E17A39E0@CEZ.ICE (view raw or flat)
Thread:
Lists: pgsql-jdbc
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

In response to

pgsql-jdbc by date

Next:From: Oliver JowettDate: 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 JurkaDate: 2007-10-18 20:18:42
Subject: Re: Fw: postgresql experts please help

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group