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
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 |