Обсуждение: 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