Re: pg_dump error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: s(dot)chava(at)wcom(dot)com (Srinivasa Rao Chava)
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump error
Date: 2002-02-25 23:12:46
Message-ID: 25177.1014678766@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

s(dot)chava(at)wcom(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Lonh SENG 2002-02-26 00:48:13 Re: Reset sequence number
Previous Message Stephan Szabo 2002-02-25 22:42:04 Re: pg_dump error