Re: Drop temporary table only if it exists - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Drop temporary table only if it exists
Date
Msg-id 200302182229.25872.josh@agliodbs.com
Whole thread Raw
In response to Re: Drop temporary table only if it exists  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Scott Ding"
Date:
Subject: point <-> polygon not supported?
Next
From: Tom Lane
Date:
Subject: Re: Rule Creates Duplicates retry