Re: pgpool versus sequences - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pgpool versus sequences
Date
Msg-id 29613.1306972929@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgpool versus sequences  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: pgpool versus sequences
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Excerpts from Tatsuo Ishii's message of mié jun 01 19:08:16 -0400 2011:
>> What pgpool really wanted to do was locking sequence tables, not
>> locking rows in sequences. I wonder why the former is not allowed.

> Yeah -- why is LOCK SEQUENCE foo_seq not allowed?  Seems a simple thing
> to have.

I don't see any particular reason to continue to disallow it, but does
that actually represent a workable solution path for pgpool?  Switching
over to that would fail on older servers.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: Re: creating CHECK constraints as NOT VALID
Next
From: Tatsuo Ishii
Date:
Subject: Re: pgpool versus sequences