On 17-10-2011 12:52, Tom Lane wrote:
"Laerson Keler"<laerson.ke...@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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
