"Rose, Juergen" <[EMAIL PROTECTED]> writes:
> We have a running postgresql 7.4 on our server (SuSE Linux 9), and at the
> moment there is no chance to upgrade. Through an 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend