| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Erol Öz <eroloz(at)esg(dot)com(dot)tr> |
| Cc: | "PostgreSQL General List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_dump - getTables() problem |
| Date: | 2001-10-23 14:49:08 |
| Message-ID: | 3904.1003848548@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"=?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 | David Link | 2001-10-23 14:50:50 | Re: Database design? |
| Previous Message | Ernesto Baschny | 2001-10-23 14:43:29 | Re: Database design? |