Re: BUG #6258: Lock Sequence

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Laerson Keler" <laerson(dot)keler(at)lkmc(dot)com(dot)br>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6258: Lock Sequence
Date: 2011-10-17 15:52:48
Message-ID: 14643.1318866768@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Laerson Keler" <laerson(dot)keler(at)lkmc(dot)com(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Laerson keler 2011-10-17 18:03:54 Re: BUG #6258: Lock Sequence
Previous Message PostgreSQL - Hans-Jürgen Schönig 2011-10-17 15:11:47 Re: char(0)