Re: sequences

Поиск
Список
Период
Сортировка
От K Parker
Тема Re: sequences
Дата
Msg-id IIKDHBOLMPKLCAAA@shared1-mail.whowhere.com
обсуждение исходный текст
Ответы Re: Re: sequences  ("Edward Q. Bridges" <ed.bridges@buzznik.com>)
Re: Re: sequences  (Charles Tassell <ctassell@isn.net>)
Список 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
whatthe 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Jesus Sandoval
Дата:
Сообщение: Application data refreshing
Следующее
От: Alexey Borzov
Дата:
Сообщение: Re[6]: WTF is going on with PG_VERSION?