X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E0E2247580B for ; Wed, 19 Feb 2003 01:30:30 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 4C05B475458 for ; Wed, 19 Feb 2003 01:30:30 -0500 (EST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2846771; Tue, 18 Feb 2003 22:30:38 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Jan Wieck Subject: Re: Drop temporary table only if it exists Date: Tue, 18 Feb 2003 22:29:25 -0800 User-Agent: KMail/1.4.3 Cc: Mintoo Lall , pgsql-sql@postgresql.org References: <20030214153413.24680.qmail@web14802.mail.yahoo.com> <200302181028.01599.josh@agliodbs.com> <3E529BF0.D373AA9C@Yahoo.com> In-Reply-To: <3E529BF0.D373AA9C@Yahoo.com> MIME-Version: 1.0 Message-Id: <200302182229.25872.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/419 X-Sequence-Number: 11817 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=20 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 overhaulin= g=20 PL/pgSQL. --=20 Josh Berkus Aglio Database Solutions San Francisco