pgsql-bugs(at)postgresql(dot)org 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