Re: BUG #15709: if drop exists syntax

Hi

čt 11. 4. 2019 v 5:53 odesílatel Jueve L <kievelee33(at)gmail(dot)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(dot)stehule(at)gmail(dot)com>
> wrote:
>
>> 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
>>
>