SYSID can no longer be specified

Started by Patrick Refondiniover 8 years ago2 messagesdocs
Jump to latest
#1Patrick Refondini
patrick.refondini@pobox.com

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.5/static/sql-createuser.html
Description:

The CREATE USER doc still states SYSID can be specified although I obtained:

SYSID can no longer be specified

while using the following command:

CREATE USER someuser WITH LOGIN ENCRYPTED PASSWORD 'somepwd' SYSID 1000;

I guess the documentation is outdated.

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Patrick Refondini (#1)
Re: SYSID can no longer be specified

patrick.refondini@pobox.com writes:

The CREATE USER doc still states SYSID can be specified although I obtained:
SYSID can no longer be specified

I don't really see a problem here. CREATE USER points you to CREATE ROLE
for everything beyond the synopsis, and CREATE ROLE clearly states

The <literal>SYSID</literal> clause is ignored, but is accepted
for backwards compatibility.

regards, tom lane

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs