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

Hi,

if lets say im using v8,3 and i need delete duplicates data without ID column and 8.3 dont have row_number() over function.
how do i write the script?? 

On Thu, Mar 21, 2019 at 9:20 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:

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