Matt Block writes:
> [prompt]$ pg_dump -s smile
> NOTICE: Unrecognized variable client_encoding
> getTables(): relation 'users': cannot find function with oid 1644 for
> trigger RI_ConstraintTrigger_196192
The notice indicates that you are using a pg_dump with multibyte support
and a server without. That's no problem by itself, but it could be a hint
that you have a version mismatch beyond that.
The function with the oid 1644 should be built-in. Grepping the source
code for the error message I have reasons to believe that you are using
pg_dump from PostgreSQL 6.5, which to no surprise cannot handle
referential integrity (which was added in 7.0). The solution would be to
use pg_dump from PostgreSQL 7.0.* or 7.1.2 or later (not in between).
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
