Randall Perry <rgp(at)systame(dot)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
In response to
pgsql-admin by date
|Next:||From: Zhang, Anna||Date: 2001-12-19 17:57:12|
|Subject: poor performance of loading data |
|Previous:||From: Randall Perry||Date: 2001-12-19 15:16:21|
|Subject: pgdump fails on trigger function|