Re: Drop temporary table only if it exists

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