BUG Postgresql 7.4.6 : usecreatedb flag - Mailing list pgsql-bugs

From Stephane Raimbault
Subject BUG Postgresql 7.4.6 : usecreatedb flag
Date
Msg-id 1103622088.6606.11.camel@picasso.lan
Whole thread Raw
Responses Re: BUG Postgresql 7.4.6 : usecreatedb flag  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hi,

This bug (I suppose it's a bug) is very simple.
Fedora Core 3/postgresql-7.4.6-1.FC3.2

su - postgres
createuser pguser
Answer yes and no so pguser can create db but can't create new user

psql template1
template1=# select * from pg_shadow;
 usename  | usesysid | usecreatedb | usesuper | usecatupd | passwd |
valuntil | useconfig
----------+----------+-------------+----------+-----------+--------
+----------+-----------
 postgres |        1 | t           | t        | t         |        |
|
 pguser   |      100 | f           | f        | f         |        |
|
(2 lignes)

The flag in usecreatedb's column is false instead of true !

Regards,

Stephane

PS : same behaviour with FC2/postgresql-7.4.6-1.FC2.2.

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: postgresql-8.0.0 beta5 & postgresql-7.4.6 can't compile successfully
Next
From: "Scott Stillwell"
Date:
Subject: [pgsql-www] BUG #1355: 8.0.0 rc2 installer fails