Обсуждение: BUG Postgresql 7.4.6 : usecreatedb flag

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.

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