Ynt: pg_dump - getTables() problem

Поиск
Список
Период
Сортировка
От Erol Öz
Тема Ynt: pg_dump - getTables() problem
Дата
Msg-id 00bd01c15bd9$22334220$0b00000a@doruk.www.doruk.net.tr
обсуждение исходный текст
Список pgsql-general
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


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

Предыдущее
От: rdacker@pacbell.net (rdack)
Дата:
Сообщение: Re: can't create a database
Следующее
От: "Mihai Gheorghiu"
Дата:
Сообщение: Re: Another error message