Re: pgdump fails on trigger function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Randall Perry <rgp(at)systame(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pgdump fails on trigger function
Date: 2001-12-19 16:08:30
Message-ID: 29997.1008778110@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Zhang, Anna 2001-12-19 17:57:12 poor performance of loading data
Previous Message Randall Perry 2001-12-19 15:16:21 pgdump fails on trigger function