Re: BUG #15709: if drop exists syntax

[image: image.png]

why MIN couldn't be use ??? is the version problem again??

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