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

čt 11. 4. 2019 v 6:17 odesílatel Jueve L <kievelee33@gmail.com> napsal:

sry, this example is with ID, which indicate rows, but from my table dont have like i was mentioned, please advice

any table has hiden column ctid, that is unique

On Thu, Apr 11, 2019 at 12:01 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:

Hi

čt 11. 4. 2019 v 5:53 odesílatel Jueve L <kievelee33@gmail.com> napsal:

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?? 

This is not a postgres bug. Please, use correct mailing list.

see https://stackoverflow.com/questions/6583916/delete-duplicate-records-in-postgresql

Regards

Pavel

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