Re: BUG #6258: Lock Sequence - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6258: Lock Sequence
Date
Msg-id 14643.1318866768@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6258: Lock Sequence  ("Laerson Keler" <laerson.keler@lkmc.com.br>)
Responses Re: BUG #6258: Lock Sequence  (Laerson keler <laerson.keler@lkmc.com.br>)
Re: BUG #6258: Lock Sequence  (Euler Taveira de Oliveira <euler@timbira.com>)
List pgsql-bugs
"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?

Why did you do that, that is what were you trying to accomplish?  It
never did block nextval() on the sequence, for example.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Laerson Keler"
Date:
Subject: BUG #6258: Lock Sequence
Next
From: Laerson keler
Date:
Subject: Re: BUG #6258: Lock Sequence