Ynt: pg_dump - getTables() problem

From: Erol Öz <eroloz(at)esg(dot)com(dot)tr>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "PostgreSQL General List" <pgsql-general(at)postgresql(dot)org>
Subject: Ynt: pg_dump - getTables() problem
Date: 2001-10-23 15:41:07
Message-ID: 00bd01c15bd9$22334220$0b00000a@doruk.www.doruk.net.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)esg(dot)com(dot)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

Browse pgsql-general by date

  From Date Subject
Next Message Vic Cekvenich 2001-10-23 16:04:35 [ANNOUNCE] Fast Track to MVC / JSP Framework Public Workshop
Previous Message Richard Welty 2001-10-23 15:36:39 openssl & postgresql