Re: Snapshot management, final - Mailing list pgsql-patches

From Alvaro Herrera
Subject Re: Snapshot management, final
Date
Msg-id 20080512005538.GE5746@alvh.no-ip.org
Whole thread Raw
In response to Re: Snapshot management, final  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Snapshot management, final  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Tom Lane wrote:

I'm revising the patch; this comment is flawed though:

> Shouldn't UnregisterSnapshot insist that s_level be equal to current
> xact nest level?

It can't check that; consider

begin;
savepoint foo;
declare cur cursor for select (1), (2), (3);
savepoint bar;
close cur;
commit;

Thanks again for the review.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: options for RAISE statement
Next
From: Tom Lane
Date:
Subject: Re: Snapshot management, final