| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Srinivasa Rao Chava <s(dot)chava(at)wcom(dot)com> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: pg_dump error |
| Date: | 2002-02-25 22:42:04 |
| Message-ID: | 20020225144030.K78044-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-02-25 23:12:46 | Re: pg_dump error |
| Previous Message | Rohit Dewan | 2002-02-25 21:36:02 | Minimum database size |