"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