Re: [PATCHES] Proposed patch for xact-vs-multixact bugs

2006-11-18 Thread Simon Riggs
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

[PATCHES] Proposed patch for xact-vs-multixact bugs

2006-11-16 Thread Tom Lane
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