Daniel F escribió: > SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE; > begin; > show transaction isolation level; > create table foo (a bigint); > insert into foo select generate_series(0, 9); > declare c1 no scroll cursor for select * from foo for update; > update foo set a=1000 where a>5; > fetch all from c1;
Interesting. If I create an non-unique index on the table before declaring the cursor, FETCH throws an error: alvherre=# fetch all from c1; ERROR: attempted to lock invisible tuple -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
