Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0 - Mailing list pgsql-bugs

pgsql-bugs@postgresql.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