Re: pg_dump - getTables() problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump - getTables() problem
Дата
Msg-id 3904.1003848548@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump - getTables() problem  ("Erol Öz" <eroloz@esg.com.tr>)
Список pgsql-general
"=?iso-8859-9?B?RXJvbCDWeg==?=" <eroloz@esg.com.tr> writes:
> getTables(): SELECT (funcname) for trigger trigger_order_t returned 0
> tuples. Expected 1.

> P.S. trigger_order_t and the function it propagates exists.

Evidently not.  Better look harder --- and keep in mind that trigger
name is not a unique identifier for a trigger.  There might be another
trigger_order_t trigger than the one you deleted.

If you're totally confused, try doing
    export PGOPTIONS="-d2"
before running pg_dump, then look in the postmaster log to see the
queries pg_dump executed.  The last one before the failure report
should be interesting.

            regards, tom lane

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

Предыдущее
От: "Ernesto Baschny"
Дата:
Сообщение: Re: Database design?
Следующее
От: Ron Peterson
Дата:
Сообщение: mail list headers