Re: getting a sequence value

Sorry, misunderstood you.

Dave

Guillaume Cottenceau wrote:

>Dave Cramer  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.
>
>  
>

-- 
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561