BUG Postgresql 7.4.6 : usecreatedb flag
Started by Stephane Raimbaultover 21 years ago2 messagesbugs
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.
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