The documentation already says prominently that roles and users are
the same thing. If you're fooling with CREATE ROLE without having
read any of that, I'm not sure that an error message will help.
I am talking about consistency here. Most people are not
going to think a role is a user, at
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> foo=# create role foo with createdb;
> CREATE ROLE
> foo=# create user foo;
> ERROR: role "foo" already exists
> 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?
Hello,
When doing:
SELECT * FROM pg_user;
foo=# select * from pg_user;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd |
valuntil | useconfig
-+--+-+--+---+--+--+---
jd | 10 | t | t
