Re: pg_dump:cannot find function for trigger

Claudio Grillo <cjg@certi.ufsc.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