pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
missing schema_name
4+ messages / 3 participants
[nested] [flat]

* missing schema_name
@ 2021-03-01 13:09 PG Doc comments form <noreply@postgresql.org>
  2021-03-01 14:43 ` Re: missing schema_name Pantelis Theodosiou <ypercube@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: PG Doc comments form @ 2021-03-01 13:09 UTC (permalink / raw)
  To: pgsql-docs@lists.postgresql.org; +Cc: hans@matfyz.cz

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.


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: missing schema_name
  2021-03-01 13:09 missing schema_name PG Doc comments form <noreply@postgresql.org>
@ 2021-03-01 14:43 ` Pantelis Theodosiou <ypercube@gmail.com>
  2021-03-01 15:29   ` Re: missing schema_name Pantelis Theodosiou <ypercube@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Pantelis Theodosiou @ 2021-03-01 14:43 UTC (permalink / raw)
  To: hans@matfyz.cz; pgsql-docs@lists.postgresql.org

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?

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: missing schema_name
  2021-03-01 13:09 missing schema_name PG Doc comments form <noreply@postgresql.org>
  2021-03-01 14:43 ` Re: missing schema_name Pantelis Theodosiou <ypercube@gmail.com>
@ 2021-03-01 15:29   ` Pantelis Theodosiou <ypercube@gmail.com>
  2021-03-10 19:42     ` Re: missing schema_name Bruce Momjian <bruce@momjian.us>
  0 siblings, 1 reply; 4+ messages in thread

From: Pantelis Theodosiou @ 2021-03-01 15:29 UTC (permalink / raw)
  To: hans@matfyz.cz; pgsql-docs@lists.postgresql.org

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.

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: missing schema_name
  2021-03-01 13:09 missing schema_name PG Doc comments form <noreply@postgresql.org>
  2021-03-01 14:43 ` Re: missing schema_name Pantelis Theodosiou <ypercube@gmail.com>
  2021-03-01 15:29   ` Re: missing schema_name Pantelis Theodosiou <ypercube@gmail.com>
@ 2021-03-10 19:42     ` Bruce Momjian <bruce@momjian.us>
  0 siblings, 0 replies; 4+ messages in thread

From: Bruce Momjian @ 2021-03-10 19:42 UTC (permalink / raw)
  To: Pantelis Theodosiou <ypercube@gmail.com>; +Cc: hans@matfyz.cz; pgsql-docs@lists.postgresql.org

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






^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2021-03-10 19:42 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-03-01 13:09 missing schema_name PG Doc comments form <noreply@postgresql.org>
2021-03-01 14:43 ` Pantelis Theodosiou <ypercube@gmail.com>
2021-03-01 15:29   ` Pantelis Theodosiou <ypercube@gmail.com>
2021-03-10 19:42     ` Bruce Momjian <bruce@momjian.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox