| 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: | Whole Thread | Raw Message | 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 #
| 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? |