Re: [COMMITTERS] pgsql: Disallow SELECT FOR UPDATE/SHARE on sequences.

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: [COMMITTERS] pgsql: Disallow SELECT FOR UPDATE/SHARE on sequences.
Дата
Msg-id 20110604.075850.1100045364736235952.t-ishii@sraoss.co.jp
обсуждение исходный текст
Список pgsql-hackers
> and even wrap around completely.  Since the row lock is ignored by nextval
> and setval, the usefulness of the operation is highly debatable anyway.

As for pgpool, this is plain wrong. The reason why pgpool uses sequene
row lock is to obtain sequence table lock like effect, which is not
currently permitted. Whether nextval and setval ignore sequence row
lock is irrelevant.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


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

Предыдущее
От: Noah Misch
Дата:
Сообщение: Assert failure when rechecking an exclusion constraint
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Error in PQsetvalue