Re: BUG #6258: Lock Sequence

On 17-10-2011 12:52, Tom Lane wrote:
> "Laerson Keler"<laerson.keler@lkmc.com.br>  writes:
>> Dear Srs, good morning, I did the automatic update postgresql 8.4.9 and
>> a function stopped working, I used the option select for update
>> in a sequence and is now giving the following error "can not lock rows in
>> sequence ...", how can I enable the blocking of the sequence?
>
You can't. It was disabled [1].

> Why did you do that, that is what were you trying to accomplish?  It
> never did block nextval() on the sequence, for example.
>
Maybe he is using an old pgpool-II version?


[1]
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=21538377ee6a0ee91f756726bd8b3de6d19fd20a


--
    Euler Taveira de Oliveira - Timbira       http://www.timbira.com.br/
    PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento