BUG Postgresql 7.4.6 : usecreatedb flag

Started by Stephane Raimbaultover 21 years ago2 messagesbugs
Jump to latest
#1Stephane Raimbault
stephane.raimbault@syneo.fr

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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Stephane Raimbault (#1)
Re: BUG Postgresql 7.4.6 : usecreatedb flag

Stephane Raimbault <stephane.raimbault@syneo.fr> writes:

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
...
The flag in usecreatedb's column is false instead of true !

Works as expected for me.

regards, tom lane