Received: from bast.unixathome.org (bast.unixathome.org [216.187.105.150]) by postgresql.org (Postfix) with ESMTP id 7621247585D for ; Sun, 24 Mar 2002 23:15:33 -0500 (EST) Received: from wocker (wocker.unixathome.org [192.168.0.99]) by bast.unixathome.org (Postfix) with ESMTP id EE3BF3F28; Sun, 24 Mar 2002 23:15:37 -0500 (EST) From: "Dan Langille" Organization: DVL Software Limited To: "jack" Date: Sun, 24 Mar 2002 23:15:36 -0500 MIME-Version: 1.0 Subject: Re: About temporary table Reply-To: dan@langille.org Cc: In-reply-to: <006b01c1d3b3$1c72b210$1400a8c0@jac> X-mailer: Pegasus Mail for Windows (v4.01) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body Message-Id: <20020325041537.EE3BF3F28@bast.unixathome.org> X-Archive-Number: 200203/303 X-Sequence-Number: 7182 Why don't you just create it at the start of where it is needed and then never worry about it. It is automatically deleted when the session finishes. On 25 Mar 2002 at 14:11, jack wrote: > But when I write SQL in pl/pgSQL, I can't test to drop a temporary table. If > it fails, the whole procedure will be aborted. That's my problem! > > JACK > > ----- Original Message ----- > From: "Bruce Momjian" > To: "jack" > Cc: > Sent: Monday, March 25, 2002 1:54 PM > Subject: Re: [SQL] About temporary table > > > > jack wrote: > > > HI, > > > > > > I installed postgreSql v7.2. There is a question about temporary tables. > How > > > can I drop a temporary table only if it exists? Thank you! > > > > Uh, just issue the drop and ignore the possible error. -- Dan Langille The FreeBSD Diary - http://freebsddiary.org/ - practical examples