Luke Tudor - RSG <ltt@pml.ac.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