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:17:11
Message-ID: CAOe5T5T2QnDebO7VULtyjq9wOr++T8APe0_9djZ+EYj1ebr2VA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

sry, this example is with ID, which indicate rows, but from my table dont
have like i was mentioned, please advice

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 Жарков Роман 2019-04-11 04:17:54 Re: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
Previous Message Pavel Stehule 2019-04-11 04:00:29 Re: BUG #15709: if drop exists syntax