RE: Re: Test for existence of Table

Поиск
Список
Период
Сортировка
От Craig L. Ching
Тема RE: Re: Test for existence of Table
Дата
Msg-id E1B42CFD544FD31193EE0000E87C5CE771015B@mailserver2.mqsoftware.com
обсуждение исходный текст
Ответ на Test for existence of Table  (Soma Interesting <dfunct@telus.net>)
Список pgsql-general
>-----Original Message-----
>From: Gregory Wood [mailto:gregw@com-stock.com]
>Sent: Thursday, January 04, 2001 9:12 PM
>To: PostgreSQL-General
>Subject: [GENERAL] Re: Test for existence of Table
>
>
>> DROP TABLE employees
>Error: ERROR:  Relation 'employees' does not exist
>
>And execution halts.... which is I believe why he wanted to check for the
>existence before trying to DROP. I'd love to know if this exists as well...
>would come in very handy during development time.
>

Execution does not halt, it continues and creates the table.  I rely on this
functionality, so I know it works.  Good luck!

>
>Greg

Cheers,
Craig

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PL/pgSQL NOT NULL variables
Следующее
От: "Gregory Wood"
Дата:
Сообщение: Re: Re: Test for existence of Table