From: s.chava@wcom.com
To: pgsql-admin@postgresql.org
Subject: pg_dump error
Date: 25 Feb 2002 13:32:43 -0800
Message-ID: <66d229f1.0202251332.3e79fa16@posting.google.com> (raw)
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 is the cause of this error and how can I fix it. We are planning
to upgrade
database to postgresql7.2 from 7.1.3 in this week. But now I'm scared
to do it in production with this problem.
Thanks for any help
chava
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: s.chava@wcom.com
Subject: Re: pg_dump error
In-Reply-To: <66d229f1.0202251332.3e79fa16@posting.google.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