Re: BUG #15709: if drop exists syntax

čt 11. 4. 2019 v 6:17 odesílatel Jueve L <kievelee33(at)gmail(dot)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(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
>>>>
>>>