From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Srinivasa Rao Chava <s.chava@wcom.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump error
Date: Mon, 25 Feb 2002 14:42:04 -0800 (PST)
Message-ID: <20020225144030.K78044-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <66d229f1.0202251332.3e79fa16@posting.google.com>
On 25 Feb 2002, Srinivasa Rao Chava wrote:
> I have recently upgraded to postgresql 7.2.
> When I try to take backup with pg_dump, one of the database is
> generating
> the following error.
>
> pg_dump: query to obtain procedure name for trigger
> "ins_extranet_cspm_bug" did not return exactly one result
>
> I checked the for the trigger "ins_extranet_cspm_bug" from
> pg_trigger system catalog table, it is retrieving just one error.
What does
select * from pg_proc where oid=<tgfoid column of the trigger>;
give you?
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: sszabo@megazone23.bigpanda.com, s.chava@wcom.com
Subject: Re: pg_dump error
In-Reply-To: <20020225144030.K78044-100000@megazone23.bigpanda.com>
* 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