From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Inconsistencies with create role |
Date: | 2005-08-22 22:46:14 |
Message-ID: | 430A55B6.6090104@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
When doing:
SELECT * FROM pg_user;
foo=# select * from pg_user;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd |
valuntil | useconfig
---------+----------+-------------+----------+-----------+----------+----------+-----------
jd | 10 | t | t | t | ******** |
|
(1 row)
Then:
foo=# create role foo with createdb;
CREATE ROLE
foo=# create user foo;
ERROR: role "foo" already exists
ERROR: role "foo" already exists
foo=# select * from pg_user;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd |
valuntil | useconfig
---------+----------+-------------+----------+-----------+----------+----------+-----------
jd | 10 | t | t | t | ******** |
|
(1 row)
I understand what is happening, but perhaps the error should be:
A role "foo" already exists which can not be the same as a username?
Or something like that...
Sincerely,
Joshua D. Drake
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2005-08-22 22:48:52 | Re: beginning hackers (was: indexes spanning multiple |
Previous Message | Andrew Dunstan | 2005-08-22 22:18:25 | Re: beginning hackers |