Received: from news.tht.net (feed.tht.net [216.126.91.242])
	by postgresql.org (Postfix) with ESMTP id 571FE475E2C
	for <pgsql-admin@postgresql.org>; Mon, 25 Feb 2002 16:50:04 -0500 (EST)
Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id
 g1PLWnt29123
	for pgsql-admin@postgresql.org; Mon, 25 Feb 2002 16:32:49 -0500 (EST)
	(envelope-from news)
From: s.chava@wcom.com (Srinivasa Rao Chava)
X-Newsgroups: comp.databases.postgresql.admin
Subject: pg_dump error
Date: 25 Feb 2002 13:32:43 -0800
Organization: http://groups.google.com/
Lines: 16
Message-ID: <66d229f1.0202251332.3e79fa16@posting.google.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: groups-abuse@google.com
To: pgsql-admin@postgresql.org
X-Archive-Number: 200202/342
X-Sequence-Number: 3495

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