Bug #482: psql (7.1.3) doesn't like sysid=0
Sherwin Daganato (win@email.com.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
Sherwin Daganato (win@email.com.ph) reports a bug with a severity of 3
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.
peter=# select version();
version
-------------------------------------------------------------
PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.96
(1 row)
peter=# create user someuser with sysid 0;
ERROR: sysid must be positive
Why not print "sysid must be greater than zero"?
Isn't that the same thing?
Why is it that zero sysid is allowed in 7.0.3 and not in
7.1.3?
.
It was never really allowed, although it's possible that older version
weren't so careful in checking. However, I'm fairly sure that the
relevant CREATE USER code was the same in 7.0.* and 7.1.*.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter