missing schema_name

Started by PG Bug reporting formabout 5 years ago4 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/sql-createschema.html
Description:

The second and forth syntax for CREATE SCHEMA is missing schema_name.

#2Pantelis Theodosiou
ypercube@gmail.com
In reply to: PG Bug reporting form (#1)
Re: missing schema_name

On Mon, Mar 1, 2021 at 1:42 PM PG Doc comments form <noreply@postgresql.org>
wrote:

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/sql-createschema.html
Description:

The second and forth syntax for CREATE SCHEMA is missing schema_name.

Right. It looks like the 2nd and 4th lines should be removed. The 1st and
3rd cover the syntax cases, don't they?

#3Pantelis Theodosiou
ypercube@gmail.com
In reply to: Pantelis Theodosiou (#2)
Re: missing schema_name

On Mon, Mar 1, 2021 at 2:43 PM Pantelis Theodosiou <ypercube@gmail.com>
wrote:

On Mon, Mar 1, 2021 at 1:42 PM PG Doc comments form <
noreply@postgresql.org> wrote:

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/sql-createschema.html
Description:

The second and forth syntax for CREATE SCHEMA is missing schema_name.

Right. It looks like the 2nd and 4th lines should be removed. The 1st and
3rd cover the syntax cases, don't they?

Oh, how silly of me. The command
CREATE SCHEMA AUTHORIZATION *role_specification*
creates a schema with same name as role_specification.

It is explained a few lines later:

*schema_name*

The name of a schema to be created. If this is omitted, the *user_name* is
used as the schema name.

#4Bruce Momjian
bruce@momjian.us
In reply to: Pantelis Theodosiou (#3)
Re: missing schema_name

On Mon, Mar 1, 2021 at 03:29:02PM +0000, Pantelis Theodosiou wrote:

On Mon, Mar 1, 2021 at 2:43 PM Pantelis Theodosiou <ypercube@gmail.com> wrote:

On Mon, Mar 1, 2021 at 1:42 PM PG Doc comments form <noreply@postgresql.org

wrote:

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/sql-createschema.html
Description:

The second and forth syntax for CREATE SCHEMA is missing schema_name.

Right. It looks like the 2nd and 4th lines should be removed. The 1st and
3rd cover the syntax cases, don't they?�

Oh, how silly of me. The command
CREATE SCHEMA AUTHORIZATION role_specification
creates a schema with same name as role_specification.�

It is explained a few lines later:

schema_name

The name of a schema to be created. If this is omitted, the�user_name�is
used as the schema name.

So, I assume our docs don't need improvement here.

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

The usefulness of a cup is in its emptiness, Bruce Lee