on 12/19/01 11:08 AM, Tom Lane at [EMAIL PROTECTED] wrote: > Randall Perry <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
