"Rose, Juergen" <Juergen.Rose@sag.de> writes:
> We have a running postgresql 7.4 on our server (SuSE Linux 9), and at the moment there is no chance to upgrade.
Throughan unusual combination of constraints (spanning over schemas) the dump cannot be imported without errors
anymore.
Try using an 8.0 or 8.1 pg_dump with the 7.4 server. 7.4's pg_dump is
not very bright about dumping things in the right order. If it still
doesn't work with a modern pg_dump, please show details.
regards, tom lane