| From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
|---|---|
| To: | Guillaume Cottenceau <gc(at)mnc(dot)ch> |
| Cc: | Nico <nicohmail-postgresql(at)yahoo(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: getting a sequence value |
| Date: | 2005-03-21 12:55:22 |
| Message-ID: | 423EC43A.9060405@fastcrypt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Sorry, misunderstood you.
Dave
Guillaume Cottenceau wrote:
>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.
>
>
>
--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nico | 2005-03-21 17:00:05 | Re: getting a sequence value |
| Previous Message | Dave Cramer | 2005-03-21 12:53:47 | Re: getting a sequence value |