Re: Drop temporary table only if it exists

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Mintoo Lall <tlqmail(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Drop temporary table only if it exists
Date: 2003-02-18 17:38:14
Message-ID: 3E526F86.69391A03@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)Yahoo(dot)com #

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Martin Davidsson 2003-02-18 17:57:12 Rule Creates Duplicates retry
Previous Message Josh Berkus 2003-02-18 17:07:21 Re: How to make sequence skip existing key in table?