Neil Conway <neilc@samurai.com> writes:
> On Wed, 2005-01-26 at 12:02 -0300, Alvaro Herrera wrote:
>> Hmm ... not sure how hard that is.
> Would it work to record the sub XID of the deleting subtxn on CLOSE, and
> then consider whether to "really" do the deletion when the subtxn
> commits/aborts?
It'd take more than that. Consider
BEGIN;DECLARE c CURSOR ...;SAVEPOINT x; CLOSE c; DECLARE c CURSOR ...; -- draws duplicate-cursor error
You'd need to do something to "hide" the deleted cursor for the
remainder of its subtransaction.
regards, tom lane