Re: pg_dump:cannot find function for trigger

Claudio Grillo <cjg(at)certi(dot)ufsc(dot)br> writes:
> getTables(): relation 'tb_bombas': cannot find function with oid 1654
> for trigger RI_ConstraintTrigger_28974

> But I can find de procedure with oid 1654 in the pg_proc, and the
> reference to this function in pg_trigger:

> pg_proc
> proname
> |proowner|prolang|proisinh|proistrusted|proiscachable|pronargs|proretset|prorettype|proargtypes|probyte_pct|properbyte_cpu|propercall_cpu|prooutin_ratio|prosrc

> |probin
> --------------------+--------+-------+--------+------------+-------------+--------+---------+----------+-----------+-----------+--------------+--------------+--------------+--------------------+------

> RI_FKey_noaction_del| 40| 11|f |t |f
> | 0|f | 0| | 100|
> 0| 0| 100|RI_FKey_noaction_del|-
> (1 row)

Hmm. Do you have a user with sysid 40 in pg_shadow? pg_dump tends to
get confused by 'owner' links that point to nonexistent users.

regards, tom lane