pgdump fails on trigger function
pgdump fails on trigger function
От:
Randall Perry <rgp@systame.com>
Дата:
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
Re: pgdump fails on trigger function
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Randall Perry 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
Re: pgdump fails on trigger function
От:
Randall Perry <rgp@systame.com>
Дата:
on 12/19/01 11:08 AM, Tom Lane at tgl@sss.pgh.pa.us wrote: > Randall Perry 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