Re: DROP TABLE IF EXISTS - Mailing list pgsql-novice

From William Yu
Subject Re: DROP TABLE IF EXISTS
Date
Msg-id cljf66$2prf$1@news.hub.org
Whole thread Raw
In response to Re: DROP TABLE IF EXISTS  (Steven Klassen <sklassen@commandprompt.com>)
Responses Re: DROP TABLE IF EXISTS
List 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@mail.nih.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
>

pgsql-novice by date:

Previous
From: Ron St-Pierre
Date:
Subject: Re: [pgfsupport - Help] RE: A big red x
Next
From: "Davis, Sean (NIH/NHGRI)"
Date:
Subject: Re: DROP TABLE IF EXISTS