Hi,
The following command makes a superuser. Is this correct?
template1=# CREATE USER xyz CREATEUSER;
CREATE ROLE
template1=# select rolname,rolsuper from pg_roles where rolname = 'xyz';
rolname | rolsuper
---------+----------
xyz | t
(1 row)
I think CREATEUSER keyword is equal to CREATEROLE.
Regards,
--
Yoshiyuki Asaba
[EMAIL PROTECTED]
Index: gram.y
===================================================================
RCS file: /projects/cvsroot/pgsql/src/backend/parser/gram.y,v
retrieving revision 2.521
diff -c -r2.521 gram.y
*** gram.y 29 Dec 2005 04:53:18 -0000 2.521
--- gram.y 9 Jan 2006 15:18:51 -0000
***************
*** 664,675 ****
}
| CREATEUSER
{
! /* For backwards compatibility, synonym
for SUPERUSER */
! $$ = makeDefElem("superuser", (Node
*)makeInteger(TRUE));
}
| NOCREATEUSER
{
! $$ = makeDefElem("superuser", (Node
*)makeInteger(FALSE));
}
| LOGIN_P
{
--- 664,675 ----
}
| CREATEUSER
{
! /* For backwards compatibility, synonym
for CREATEROLE */
! $$ = makeDefElem("createrole", (Node
*)makeInteger(TRUE));
}
| NOCREATEUSER
{
! $$ = makeDefElem("createrole", (Node
*)makeInteger(FALSE));
}
| LOGIN_P
{
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
