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