Re: BUG #15709: if drop exists syntax

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

> On Thu, Apr 11, 2019 at 12:48 PM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
>
>>
>>
>> čt 11. 4. 2019 v 6:44 odesílatel Jueve L <kievelee33(at)gmail(dot)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(dot)stehule(at)gmail(dot)com>
>>> wrote:
>>>
>>>>
>>>>
>>>> č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
>>>>>>>>
>>>>>>>