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(dot)stehule(at)gmail(dot)com>
wrote:

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