Re: CREATE USER and pg_user - Mailing list pgsql-hackers

From Tom Lane
Subject Re: CREATE USER and pg_user
Date
Msg-id 7731.1123857710@sss.pgh.pa.us
Whole thread Raw
In response to CREATE USER and pg_user  ("William ZHANG" <uniware@zedware.org>)
List pgsql-hackers
"William ZHANG" <uniware@zedware.org> writes:
> Why not change the option "createuser" to "superuser",

Backwards compatibility with existing dump files.

> or do something to make is easier to understand?

See
http://developer.postgresql.org/docs/postgres/sql-createrole.html

SUPERUSER
NOSUPERUSER
    These clauses determine whether the new role is a "superuser", who can override all access restrictions within the
 database. Superuser status is dangerous and should be used only when really needed. You must yourself be a
superuserto create a new superuser. If not specified, NOSUPERUSER is the default. 
 

...

CREATEUSER
NOCREATEUSER
    These clauses are an obsolete, but still accepted, spelling of SUPERUSER and NOSUPERUSER. Note that they are    not
equivalentto CREATEROLE as one might naively expect! 
 
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: obtaining row locking information
Next
From: Mark Wong
Date:
Subject: Re: data on devel code perf dip