Обсуждение: Ynt: pg_dump - getTables() problem

Поиск
Список
Период
Сортировка

Ynt: pg_dump - getTables() problem

От
"Erol Öz"
Дата:
Hi,
Thanks Tom,
You are right as always. I had another trigger with same name, which I have
forgotten to drop. After I droped it, the problem disappeared.
Thanks again.
Erol

>"=?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