From: | pgsql-bugs(at)postgresql(dot)org |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Bug #482: psql (7.1.3) doesn't like sysid=0 |
Date: | 2001-10-15 16:22:23 |
Message-ID: | 200110151622.f9FGMNO53532@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Sherwin Daganato (win(at)email(dot)com(dot)ph) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
psql (7.1.3) doesn't like sysid=0
Long Description
I have migrated a production database from 7.0.3
to 7.1.3 successfully. Then I was trying to load this
database (7.1.3) to a development machine with
another 7.1.3 when I encounter the error. It is not
clear in the docs that sysid should be positive and
the error message is a little bit confusing.
Why not print "sysid must be greater than zero"?
Why is it that zero sysid is allowed in 7.0.3 and not in
7.1.3?
.
$ psql -f dump.db template1
psql:dumpall_pg:11: ERROR: sysid must be positive
<snip from dump.db>
CREATE USER "root" WITH SYSID 0 CREATEDB CREATEUSER;
</snip from dump.db>
Sample Code
No file was uploaded with this report
From | Date | Subject | |
---|---|---|---|
Next Message | Lora Goldston | 2001-10-15 16:23:49 | unknown object exception in postgresql-7.1.3 jdbc driver |
Previous Message | Stephan Szabo | 2001-10-15 15:45:37 | Re: probably a bug of data-type serial |