Re: Portals and nested transactions

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Portals and nested transactions
Дата
Msg-id 20040715024641.GB29825@dcc.uchile.cl
обсуждение исходный текст
Ответ на Re: Portals and nested transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Portals and nested transactions
Список 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 по дате отправления:

Предыдущее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: Release planning (was: Re: Status report)
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCHES] serverlog rotation/functions