Snapshot warning - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Snapshot warning
Date
Msg-id 2e78013d0811232335i48cdf581m77ae44027a58544@mail.gmail.com
Whole thread Raw
Responses Re: Snapshot warning  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Snapshot warning  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
<br />Following test case gives a warning of snapshot not destroyed at commit time.<br /><br />CREATE TABLE test (a
int);<br />INSERT INTO test VALUES (1);<br />BEGIN;<br /> DECLARE c CURSOR FOR SELECT * FROM test FOR update;<br />
SAVEPOINTA;<br /> FETCH -2 FROM c;<br /> ROLLBACK TO SAVEPOINT A;<br /> COMMIT;<br /><br />Should we call
FreeQueryDesc()even for failed portals in PortalCleanup() ? Or PortalDrop() is a better(right) place to do that ?<br
/><br/>Thanks,<br />Pavan<br clear="all" /><br />-- <br />Pavan Deolasee<br />EnterpriseDB     <a
href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br/> 

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Visibility map, partial vacuums
Next
From: "Pavan Deolasee"
Date:
Subject: Re: Review: Hot standby