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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
