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.