X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 2528C474E4F
	for <pgsql-sql@postgresql.org>; Fri, 14 Feb 2003 10:34:09 -0500 (EST)
Received: from web14802.mail.yahoo.com (web14802.mail.yahoo.com
	[216.136.224.218])
	by postgresql.org (Postfix) with SMTP id 70F2A474E42
	for <pgsql-sql@postgresql.org>; Fri, 14 Feb 2003 10:34:08 -0500 (EST)
Message-ID: <20030214153413.24680.qmail@web14802.mail.yahoo.com>
Received: from [66.139.15.154] by web14802.mail.yahoo.com via HTTP;
	Fri, 14 Feb 2003 07:34:13 PST
Date: Fri, 14 Feb 2003 07:34:13 -0800 (PST)
From: Mintoo Lall <tlqmail@yahoo.com>
Subject: Drop temporary table only if it exists
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-182278681-1045236853=:24294"
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/330
X-Sequence-Number: 11728

--0-182278681-1045236853=:24294
Content-Type: text/plain; charset=us-ascii


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

Any help is appreciated .

Thanks,

Tarun



---------------------------------
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
--0-182278681-1045236853=:24294
Content-Type: text/html; charset=us-ascii

<P>Hi Everybody,</P>
<P>How do I drop a temporary table ( or for that matter a sequence) only if it exists&nbsp; or create them if they donot exist ? I want to do this to avoid any errors</P>
<P>Any help is appreciated .</P>
<P>Thanks,</P>
<P>Tarun</P><p><br><hr size=1>Do you Yahoo!?<br>
<a href="http://rd.yahoo.com/O=1/I=brandr/vday03/text/flow/*http://shopping.yahoo.com
/shop?d=browse&id=20146735">Yahoo! Shopping</a> - Send Flowers for Valentine's Day
--0-182278681-1045236853=:24294--