BUG #15709: if drop exists syntax

Started by PG Bug reporting formabout 7 years ago10 messagesbugs

noreply@postgresql.org

about 7 years ago

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

Pavel Stehule

pavel.stehule@gmail.com

about 7 years ago

In reply to: PG Bug reporting form (#1)

Re: BUG #15709: if drop exists syntax

č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

Jueve L

kievelee33@gmail.com

about 7 years ago

In reply to: Pavel Stehule (#2)

Re: BUG #15709: if drop exists syntax

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:

Show quoted text

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

Pavel Stehule

pavel.stehule@gmail.com

about 7 years ago

In reply to: Jueve L (#3)

Re: BUG #15709: if drop exists syntax

č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

Show quoted text

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

Jueve L

kievelee33@gmail.com

about 7 years ago

In reply to: Pavel Stehule (#4)

Re: BUG #15709: if drop exists syntax

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

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

Show quoted text

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

Pavel Stehule

pavel.stehule@gmail.com

about 7 years ago

In reply to: Jueve L (#5)

Re: BUG #15709: if drop exists syntax

č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

Show quoted text

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

Jueve L

kievelee33@gmail.com

about 7 years ago

In reply to: Pavel Stehule (#6)

Re: BUG #15709: if drop exists syntax

[image: image.png]

why MIN couldn't be use ??? is the version problem again??

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

Show quoted text

č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

Pavel Stehule

pavel.stehule@gmail.com

about 7 years ago

In reply to: Jueve L (#7)

Re: BUG #15709: if drop exists syntax

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

[image: image.png]

why MIN couldn't be use ??? is the version problem again??

i have not a idea

Show quoted text

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

č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

Jueve L

kievelee33@gmail.com

about 7 years ago

In reply to: Pavel Stehule (#8)

Re: BUG #15709: if drop exists syntax

[image: image.png]
not the MIN cannot be use, is the ctid, how could the ctid in this format??
this ensure cannot be MIN.. please advice, got any unique key?? to do
duplicates data??

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

Show quoted text

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

[image: image.png]

why MIN couldn't be use ??? is the version problem again??

i have not a idea

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

č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

#10

Pavel Stehule

pavel.stehule@gmail.com

about 7 years ago

In reply to: Jueve L (#9)

Re: BUG #15709: if drop exists syntax

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

[image: image.png]
not the MIN cannot be use, is the ctid, how could the ctid in this
format?? this ensure cannot be MIN.. please advice, got any unique key?? to
do duplicates data??

can you move data to modern database and do deduplication there?

Without MIN on ctid you cannot to do it. You can write a extension in C
language, but it is probably out of scope.

Show quoted text

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

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

[image: image.png]

why MIN couldn't be use ??? is the version problem again??

i have not a idea

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

č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

BUG #15709: if drop exists syntax

Attachments:

Attachments:

Attachments:

Attachments: