Re: getting a sequence value - Mailing list pgsql-jdbc

From Guillaume Cottenceau
Subject Re: getting a sequence value
Date
Msg-id 87y8chtb35.fsf@meuh.mnc.ch
Whole thread Raw
In response to Re: getting a sequence value  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: getting a sequence value
List pgsql-jdbc
Dave Cramer <pg 'at' fastcrypt.com> writes:

> Guillaume,
>
> No it can't be wrong from the database's point of view, now what
> happens in java is another problem

Yes, of course :)

> Here's how it works, in principle anyway.
>
> The last value of each sequence which has been generated using nextval
> is stored in the connections session memory.
> so when you use the SAME connection to retrieve currval it will
> retrieve that value.

We agree. And what the original poster wanted to do with his data
will be incorrect.

--
Guillaume Cottenceau

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: getting a sequence value
Next
From: Dave Cramer
Date:
Subject: Re: getting a sequence value