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