Re: pgdump fails on trigger function

on 12/19/01 11:08 AM, Tom Lane at tgl(at)sss(dot)pgh(dot)pa(dot)us wrote:

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

Thanks, I'll check it out.

--
Randy Perry
sysTame
Mac Consulting/Sales

phn 561.589.6449
mobile email help(at)systame(dot)com