Received: from mail1.tpgi.com.au (mail.tpgi.com.au [203.12.160.57]) by postgresql.org (Postfix) with ESMTP id A5BF24758F6 for ; Mon, 1 Apr 2002 22:41:47 -0500 (EST) Received: from jac (bri-ppp-097.tpgi.com.au [203.12.164.97]) by mail1.tpgi.com.au (8.11.6/8.11.6) with SMTP id g323fuK23827 for ; Tue, 2 Apr 2002 13:41:56 +1000 Message-ID: <002501c1d9f8$564a6f00$1400a8c0@jac> From: "jack" To: References: <200203252105.g2PL5TD16361@candle.pha.pa.us> Subject: Re: About temporary table Date: Tue, 2 Apr 2002 13:41:55 +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: 200204/11 X-Sequence-Number: 7276 To solve this problem, I think it's better to have "DROP TABLE xxx ONLY-IF-EXISTING" JACK