Re: [COMMITTERS] pgsql: Disallow SELECT FOR UPDATE/SHARE on sequences. - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: [COMMITTERS] pgsql: Disallow SELECT FOR UPDATE/SHARE on sequences.
Date
Msg-id 20110604.075850.1100045364736235952.t-ishii@sraoss.co.jp
Whole thread Raw
List 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 by date:

Previous
From: Noah Misch
Date:
Subject: Assert failure when rechecking an exclusion constraint
Next
From: Merlin Moncure
Date:
Subject: Re: Error in PQsetvalue