X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9A365475AAC for ; Tue, 18 Feb 2003 12:40:04 -0500 (EST) Received: from smtp011.mail.yahoo.com (smtp011.mail.yahoo.com [216.136.173.31]) by postgresql.org (Postfix) with SMTP id E0170475A9E for ; Tue, 18 Feb 2003 12:40:03 -0500 (EST) Received: from psc.progress.com (HELO Yahoo.com) (janwieck@192.233.92.200 with plain) by smtp.mail.vip.sc5.yahoo.com with SMTP; 18 Feb 2003 17:40:09 -0000 Message-ID: <3E526F86.69391A03@Yahoo.com> Date: Tue, 18 Feb 2003 12:38:14 -0500 From: Jan Wieck Organization: Home X-Mailer: Mozilla 4.8 [en] (Windows NT 5.0; U) X-Accept-Language: en,ru MIME-Version: 1.0 To: Mintoo Lall Cc: pgsql-sql@postgresql.org Subject: Re: Drop temporary table only if it exists References: <20030214153413.24680.qmail@web14802.mail.yahoo.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/411 X-Sequence-Number: 11809 Mintoo Lall wrote: > > Hi Everybody, > > How do I drop a temporary table ( or for that matter a sequence) only > if it exists or create them if they donot exist ? I want to do this > to avoid any errors I wonder what type of application cannot remember if it created a temp object or not during the lifetime of it's database connection. Jan > > Any help is appreciated . > > Thanks, > > Tarun > > ---------------------------------------------------------------------- > Do you Yahoo!? > Yahoo! Shopping - Send Flowers for Valentine's Day -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #