Re: pgdump fails on trigger function - Mailing list pgsql-admin

From Tom Lane
Subject Re: pgdump fails on trigger function
Date
Msg-id 29997.1008778110@sss.pgh.pa.us
Whole thread Raw
In response to pgdump fails on trigger function  (Randall Perry <rgp@systame.com>)
Responses Re: pgdump fails on trigger function  (Randall Perry <rgp@systame.com>)
List pgsql-admin
Randall Perry <rgp@systame.com> writes:
> Anyone know what this means:
> getTables(): SELECT (funcname) for trigger cust_modification_date returned 0
> tuples. Expected 1.

It would seem you have dropped the function which that trigger uses.
(If you drop and recreate a function, you have to drop and recreate
any triggers that use it too.  The triggers refer to the function by
OID, but the recreated function will have a different OID.)

            regards, tom lane

pgsql-admin by date:

Previous
From: Randall Perry
Date:
Subject: pgdump fails on trigger function
Next
From: "Zhang, Anna"
Date:
Subject: poor performance of loading data