Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178])
	by postgresql.org (Postfix) with ESMTP id 88358475DBB
	for <pgsql-admin@postgresql.org>; Mon, 25 Feb 2002 17:42:07 -0500 (EST)
Received: by megazone.bigpanda.com (Postfix, from userid 1001)
	id 69C7DD5FD; Mon, 25 Feb 2002 14:42:04 -0800 (PST)
Received: from localhost (localhost [127.0.0.1])
	by megazone.bigpanda.com (Postfix) with ESMTP
	id 5F76E5BF9; Mon, 25 Feb 2002 14:42:04 -0800 (PST)
Date: Mon, 25 Feb 2002 14:42:04 -0800 (PST)
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
In-Reply-To: <66d229f1.0202251332.3e79fa16@posting.google.com>
Message-ID: <20020225144030.K78044-100000@megazone23.bigpanda.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200202/343
X-Sequence-Number: 3496

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?