Re: BUG #15709: if drop exists syntax - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: BUG #15709: if drop exists syntax
Date
Msg-id CAFj8pRBBH7aOgROm583Eo0HgNQ82ZtLp-3T0i6iE=3SZ3TERfg@mail.gmail.com
Whole thread Raw
In response to BUG #15709: if drop exists syntax  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15709: if drop exists syntax  (Jueve L <kievelee33@gmail.com>)
List pgsql-bugs
Hi

čt 21. 3. 2019 v 11:44 odesílatel PG Bug reporting form <noreply@postgresql.org> napsal:
The following bug has been logged on the website:

Bug reference:      15709
Logged by:          Kieve Lee
Email address:      kievelee33@gmail.com
PostgreSQL version: Unsupported/Unknown
Operating system:   window 7
Description:       

How about if in version 8.0, how do we use drop table if exists?? If you
dont provide this function then provide a script example dude, why pgsql so
unfriendly??

This is not a bug.

Please, try to use supported version of PostgreSQL. 8.0 is unsupported maybe ten years.

psql run in fault tolerant mode where errors are ignored. So you can just

drop table sometable;
create table sometable(...);

It should to works. The error messages you can ignore.

Regards

Pavel Stehule

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15710: ADD COLUMN IF NOT EXISTS adds constraint anyways
Next
From: Tom Lane
Date:
Subject: Re: BUG #15710: ADD COLUMN IF NOT EXISTS adds constraint anyways