Re: BUG #15709: if drop exists syntax

From: Jueve L <kievelee33(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15709: if drop exists syntax
Date: 2019-04-11 04:43:53
Message-ID: CAOe5T5SECtaLn678o8PdA90mi_Yq7P7yxzx8XJBvJd8x4bEW1A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Munro 2019-04-11 04:44:37 Re: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
Previous Message Pavel Stehule 2019-04-11 04:32:49 Re: BUG #15709: if drop exists syntax