[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

Reply via email to