Re: BUG #15709: if drop exists syntax

Поиск
Список
Период
Сортировка
От Jueve L
Тема Re: BUG #15709: if drop exists syntax
Дата
Msg-id CAOe5T5TL0auhP7Ln+yy3b11Ywfp+uW9R2Dun7mTOHEpCmP1ocg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15709: if drop exists syntax  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
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?? 

On Thu, Mar 21, 2019 at 9:20 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:
Hi

čt 21. 3. 2019 v 11:44 odesílatel PG Bug reporting form <noreply@postgresql.org> napsal:
The following bug has been logged on the website:

Bug reference:      15709
Logged by:          Kieve Lee
Email address:      kievelee33@gmail.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

В списке pgsql-bugs по дате отправления: