Обсуждение: pgdump fails on trigger function

Anyone know what this means:

getTables(): SELECT (funcname) for trigger cust_modification_date returned 0
tuples. Expected 1.
pg_dump failed on tasbill, exiting

Tried deleting and recreating the trigger. After restarting the postmaster
pgdump works ok once. The next time it runs it fails again with the same
error.


--
Randy Perry
sysTame
Mac Consulting/Sales

phn                 561.589.6449
mobile email        help@systame.com

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

on 12/19/01 11:08 AM, Tom Lane at tgl@sss.pgh.pa.us wrote:

> 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.)
>

Thanks, I'll check it out.



--
Randy Perry
sysTame
Mac Consulting/Sales

phn                 561.589.6449
mobile email        help@systame.com