Ynt: pg_dump - getTables() problem - Mailing list pgsql-general

From Erol Öz
Subject Ynt: pg_dump - getTables() problem
Date
Msg-id 00bd01c15bd9$22334220$0b00000a@doruk.www.doruk.net.tr
Whole thread Raw
List 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 by date:

Previous
From: rdacker@pacbell.net (rdack)
Date:
Subject: Re: can't create a database
Next
From: "Mihai Gheorghiu"
Date:
Subject: Re: Another error message