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