From: | "K Parker" <kparker(at)eudoramail(dot)com> |
---|---|
To: | pgsql-general(at)hub(dot)org |
Subject: | Re: sequences |
Date: | 2000-09-21 06:13:23 |
Message-ID: | IIKDHBOLMPKLCAAA@shared1-mail.whowhere.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Edward Q. Bridges's detailed statement regarding sequences, of which I extract merely the most pessimistic part:
> begin;
> insert into foo (A,B) values (B);
> select currval('foo_A_seq');
> commit;
>
> note that the transaction is key, without
> which there's no guarantee that some other
> statement will affect the value of the
> sequence.
quite clearly conflicts what what seems to me to be the plain meaning of the manual page for CREATE SEQUENCE which states, in part:
> multiple backends are guaranteed to
> allocate distinct sequence values
Can some knowledgable person here save a bunch of us plain old user-programmers the trouble of trying to trace down what the source says and just clarify this issue? Thanks!
>
Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com
From | Date | Subject | |
---|---|---|---|
Next Message | Alexey Borzov | 2000-09-21 06:53:55 | Re[6]: WTF is going on with PG_VERSION? |
Previous Message | Jesus Sandoval | 2000-09-21 05:23:13 | Application data refreshing |