| From: | Stephane Raimbault <stephane(dot)raimbault(at)syneo(dot)fr> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG Postgresql 7.4.6 : usecreatedb flag |
| Date: | 2004-12-21 09:41:28 |
| Message-ID: | 1103622088.6606.11.camel@picasso.lan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joerg Schubert | 2004-12-21 10:13:37 | unsubscribe pgsql-bugs@postgresql.org |
| Previous Message | Tom Lane | 2004-12-21 07:35:17 | Re: problem with 8.0rc1 not using indexes (more info) |