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 | |

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.



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Stephane Raimbault <stephane.raimbault (AT) syneo (DOT) fr> writes:
Works as expected for me.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match