Re: Error dropping non-existent tables

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Error dropping non-existent tables
Дата
Msg-id 20041120165113.GA23127@wolff.to
обсуждение исходный текст
Ответ на Error dropping non-existent tables  (Baldeep Hira <baldeephira@gmail.com>)
Ответы Re: Error dropping non-existent tables  (Baldeep Hira <baldeephira@gmail.com>)
Список pgsql-general
On Fri, Nov 19, 2004 at 21:38:33 -0800,
  Baldeep Hira <baldeephira@gmail.com> wrote:
>
> I am able to drop tables in PostgreSQL, but the problem arises when
> the table does not exist and I try to execute a "drop table" command.

The simplest fix is to do the drop table outside of a transaction (so
that the error in the drop doesn't break the rest of your script).
If that won't work for you then you can write a custom function that
looks in the system catalog to see if the table exists before trying
the drop.

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

Предыдущее
От: Sebastian Böck
Дата:
Сообщение: infinite recursion detected in rules for relation "..."
Следующее
От: Tom Lane
Дата:
Сообщение: Re: infinite recursion detected in rules for relation "..."