Received: from mail2.tpgi.com.au (mail.tpgi.com.au [203.12.160.58]) by postgresql.org (Postfix) with ESMTP id 9066347545C for ; Sun, 24 Mar 2002 23:11:15 -0500 (EST) Received: from jac (bri4-56k-247.tpgi.com.au [202.7.185.247]) by mail2.tpgi.com.au (8.11.6/8.11.6) with SMTP id g2P4BH009604 for ; Mon, 25 Mar 2002 15:11:17 +1100 Message-ID: <006b01c1d3b3$1c72b210$1400a8c0@jac> From: "jack" To: References: <200203250354.g2P3sEC02066@candle.pha.pa.us> Subject: Re: About temporary table Date: Mon, 25 Mar 2002 14:11:16 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200203/302 X-Sequence-Number: 7181 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. > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >