Re: Portals and nested transactions - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Portals and nested transactions
Date
Msg-id 20040715024641.GB29825@dcc.uchile.cl
Whole thread Raw
In response to Re: Portals and nested transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Portals and nested transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, Jul 14, 2004 at 03:11:54PM -0400, Tom Lane wrote:
> Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> > On Tue, Jul 13, 2004 at 04:57:06PM -0400, Tom Lane wrote:
> >> I've been thinking about what to do with cursors in subtransactions.
> 
> > So within this proposal, a query executed by normal means will get its
> > resources saved in the transaction ResourceOwner?
> 
> No, *all* queries are executed within portals.  The reason we need a
> transaction ResourceOwner is because query parsing/planning happens in
> advance of creating the portal, so we need someplace to keep track of
> resources acquired during that process.

Ah-ha, got it (should have known better).

Do you want me to do the legwork for this to happen, or was your initial
plan to do it yourself?  Either way is OK with me ...

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Granting software the freedom to evolve guarantees only different results,
not better ones." (Zygo Blaxell)



pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Release planning (was: Re: Status report)
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] serverlog rotation/functions