Re: Drop temporary table only if it exists - Mailing list pgsql-sql

From Jan Wieck
Subject Re: Drop temporary table only if it exists
Date
Msg-id 3E526F86.69391A03@Yahoo.com
Whole thread Raw
In response to Drop temporary table only if it exists  (Mintoo Lall <tlqmail@yahoo.com>)
Responses Re: Drop temporary table only if it exists  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
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 #


pgsql-sql by date:

Previous
From: miquels@cistron-office.nl (Miquel van Smoorenburg)
Date:
Subject: Re: convert from an integer to a date
Next
From: "Martin Davidsson"
Date:
Subject: Rule Creates Duplicates retry