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?