Re: DROP TABLE IF EXISTS

From: William Yu <wyu(at)talisys(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: DROP TABLE IF EXISTS
Date: 2004-10-25 18:05:36
Message-ID: cljf66$2prf$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm not sure why this even matters. You do DROP TABLE on a table that
doesn't exist, all that will happen is that you will get an error back
but your program will continue on it's merry way anyways. The only thing
IF EXISTS would give you is the suppression of the error message.

Steven Klassen wrote:

> * Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> [2004-10-21 12:26:47 -0400]:
>
>
>>I am wondering how to do this simple mysql task in postgres. Any
>>hints?
>
>
> This reply from Ron Johnson seems to suffice:
>
> http://archives.postgresql.org/pgsql-interfaces/2002-05/msg00102.php
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Davis, Sean (NIH/NHGRI) 2004-10-25 20:28:29 Re: DROP TABLE IF EXISTS
Previous Message Ron St-Pierre 2004-10-25 16:17:34 Re: [pgfsupport - Help] RE: A big red x