Обсуждение: pg_dump error

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

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?

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