[EMAIL PROTECTED] writes: > 1. error the user root has id 0 and the import says: > You are now connected to database template1.
> DELETE 0 > psql:old713:7: ERROR: user id must be positive This is not a bug, but enforcement of a restriction that has always been there. You'll need to give that user some other sysid value. > 2. tables with complex foreign key constrains will not be imported I cannot see any problem using your schema: 7.1 dumps it and 7.2 loads it just fine, as far as I can tell. You'll need to be more specific about what is going wrong for you. You might also need to supply some test data, not just a schema. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster