On Thu, 2006-11-16 at 20:23 -0500, Tom Lane wrote:
We should treat
exclusive lock held under any of the current backend's subtransactions
as not to be overridden.
I can't find any clear discussion of this within the docs. I guess if
there were some clear statements on this it would have been
The attached patch fixes the problem discussed here
http://archives.postgresql.org/pgsql-hackers/2006-11/msg00357.php
as well as a related problem that I discovered while working on it:
the sequence
begin;
savepoint x;
select * from foo for update;
release savepoint x;
select * from foo for