Re: Transaction control in procedures - Mailing list pgsql-hackers

From legrand legrand
Subject Re: Transaction control in procedures
Date
Msg-id 1510699256641-0.post@n3.nabble.com
Whole thread Raw
In response to Re: [HACKERS] Transaction control in procedures  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Transaction control in procedures  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
will that kind of statement (that is permitted with Oracle but gives errors
ora-1555 snapshot too old) be permitted ?

beginfor c in (select id from tab where cond='blabla')loop   update tab set x=1 where id=c.id;   commit;end loop;
end;






--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html


pgsql-hackers by date:

Previous
From: Ashwin Agrawal
Date:
Subject: Re: [HACKERS] Commits don't block for synchronous replication
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] SQL procedures