Re: Function not working check_foreign_key().

Luke Tudor - RSG <ltt(at)pml(dot)ac(dot)uk> writes:
> The problem started one day months ago when suddenly, pg_dump stopped
> working! I don't have an explanation as to why, because Im not sure what
> changed. Anyway;

> I started getting the error message 'getTables(): relation 'genuser':
> cannot find function with oid 773217 for trigger check_user'.

After some digging, I find that pg_dump hasn't emitted an error message
spelled like that since version 6.5. You really ought to upgrade.

It also appears that the 6.5 pg_dump will give that error message for
several reasons other than not finding the OID:
(a) there is no pg_shadow entry matching the trigger function's
proowner field in pg_proc;
(b) the function is not declared to take zero arguments;
(c) the function is not declared to return OPAQUE.

Offhand I will bet that (a) is your problem. Create a new user with
the right usesysid and you'll be OK again.

regards, tom lane