Alvaro Herrera <[EMAIL PROTECTED]> 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. > How is the "unnamed portal" affected by it? Same as the rest. I don't recall whether SPI creates actual portals, but we'd definitely want it to create a new ResourceOwner for queries it runs. > On the other hand, some people supported the idea that v3 Bind portals > should behave nontransactionally, while DECLARE portals should behave > transactionally. Maybe we could make that a property of the portal, or > even a user-selectable property (where we would define a reasonable > default behavior). This is certainly possible. Whether it's a good idea needs further discussion... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])