[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] pgdump fails on trigger function
From:       Randall Perry <rgp () systame ! com>
Date:       2001-12-20 15:21:12
[Download RAW message or body]

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




---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
[prev in list] [next in list] [prev in thread] [next in thread]