| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | tammer(at)tammer(dot)net, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0 |
| Date: | 2002-02-10 23:48:28 |
| Message-ID: | 24503.1013384908@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pgsql-bugs | 2002-02-11 07:47:04 | Bug #579: Auto-VACUUM doesnt work |
| Previous Message | Rainer Tammer | 2002-02-09 06:58:55 | Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in |