Re: Fw: postgresql experts please help

On Thu, 2007-10-18 at 13:41 -0400, Kris Jurka wrote:
>
> On Thu, 18 Oct 2007, Mark Lewis wrote:
>
> > You haven't disabled JDBC autocommit for this connection.  That means
> > that each statement gets executed in a separate transaction.
> >
> > Since currval is only valid within the scope of a single transaction,
> > and you're executing your "select currval" from a separate transaction,
> > that's why you can't see it.
> >
>
> False.  currval maintains state across transactions:

Oops.  I knew that-- not thinking straight this morning I guess :)  I
wish mailing list archives had take-backs.