Re: pg_dump error - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump error
Date
Msg-id 25177.1014678766@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump error  (s.chava@wcom.com (Srinivasa Rao Chava))
List pgsql-admin
s.chava@wcom.com (Srinivasa Rao Chava) writes:
> pg_dump: query to obtain procedure name for trigger
> "ins_extranet_cspm_bug" did not return exactly one result

The most likely bet is that there's no function at all that matches the
OID stored in the trigger.  Have you done any deletion/recreation of
functions in the new database?

The error message that 7.2's pg_dump emits here seems less helpful than
the old one :-(.  Will see if I can tweak it.

            regards, tom lane

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: pg_dump error
Next
From: "Lonh SENG"
Date:
Subject: Re: Reset sequence number