Jan,
> All temporary objects that need to persist across transactions should be
> created at session start. Everything else is created inside the
> transaction that needs it and is therefore automatically cleaned up.
That's a good idea for Mintoo: open your temporary objects inside a
transaction. Then you can dismiss them by rolling back the transaction.
> I never needed to. I might when I come around and create the next
> generation of PL that supports packages with package initialization
> functions and the like. Let's see ...
Hey, drop a line by David Fetter. He's been making noises about overhauling
PL/pgSQL.
--
Josh Berkus
Aglio Database Solutions
San Francisco