Re: BUG #15709: if drop exists syntax

Hi

čt 21. 3. 2019 v 11:44 odesílatel PG Bug reporting form <
noreply(at)postgresql(dot)org> napsal:

> The following bug has been logged on the website:
>
> Bug reference: 15709
> Logged by: Kieve Lee
> Email address: kievelee33(at)gmail(dot)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