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

From Tom Lane
Subject Re: pg_dump - getTables() problem
Date
Msg-id 3904.1003848548@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump - getTables() problem  ("Erol Öz" <eroloz@esg.com.tr>)
List 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 by date:

Previous
From: "Ernesto Baschny"
Date:
Subject: Re: Database design?
Next
From: Ron Peterson
Date:
Subject: mail list headers