Re: SERIAL Field

Поиск
Список
Период
Сортировка
Искать
От
Joel Stevenson
Тема
Re: SERIAL Field
Дата
в 15:49:31
Msg-id
a05111709b8fc88c96775@[192.168.1.100]
Ответ на
Re: SERIAL Field (Dan Langille)
Список
Дерево обсуждения
Re: SERIAL Field Brian McCane <bmccane@mccons.net>
>  > "You say nextval() + write, I say write + currval()..."
>
>So long as a given application does not mix the two approaches, everything
>should be fine.

Though, if you have multiple clients inserting into the table, there 
is a chance that between client A inserting the record and then 
calling currval(), client B could have performed an insert, in which 
case client A gets the value of client B's record.  'nextval() + 
write' avoids this possible overlap.
-- 
Joel Stevenson
Bear River Associates, Inc.
В списке pgsql-admin по дате отправления
От: Brian McCane
Дата:
Сообщение: Re: SERIAL Field
От: Tom Lane
Дата:
Сообщение: Re: SERIAL Field
FAQ