Re: BUG #15709: if drop exists syntax

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