From: Tom Lane <tgl@sss.pgh.pa.us>
To: s.chava@wcom.com
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump error
Date: Mon, 25 Feb 2002 18:12:46 -0500
Message-ID: <25177.1014678766@sss.pgh.pa.us> (raw)
In-Reply-To: <66d229f1.0202251332.3e79fa16@posting.google.com>
References: <66d229f1.0202251332.3e79fa16@posting.google.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, s.chava@wcom.com
Subject: Re: pg_dump error
In-Reply-To: <25177.1014678766@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox