Обсуждение: Documentation for CommandComplete is incorrect for CREATE TABLE withserver version 10.2

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/static/protocol-message-formats.html
Description:

On this page:
https://www.postgresql.org/docs/10/static/protocol-message-formats.html

The documentation says:

For a SELECT or CREATE TABLE AS command, the tag is SELECT rows where rows
is the number of rows retrieved.

But what I get back from the server is this packet:

0000   43 00 00 00 11 43 52 45 41 54 45 20 54 41 42 4c  C....CREATE TABL
0010   45 00                                            E.

The query I sent to the server was:

create table table1(i int)

PG Doc comments form wrote:

> The documentation says:
> 
> For a SELECT or CREATE TABLE AS command, the tag is SELECT rows where rows
> is the number of rows retrieved.
> 
> But what I get back from the server is this packet:
> 
> 0000   43 00 00 00 11 43 52 45 41 54 45 20 54 41 42 4c  C....CREATE TABL
> 0010   45 00                                            E.
> 
> The query I sent to the server was:
> 
> create table table1(i int)

Yeah, this is not a CREATE TABLE AS.  It's a plain CREATE TABLE.
Different thing.

alvherre=# create table dcm as select 'foo';
SELECT 1

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

=?utf-8?q?PG_Doc_comments_form?= <noreply@postgresql.org> writes:
> The documentation says:
> For a SELECT or CREATE TABLE AS command, the tag is SELECT rows where rows
> is the number of rows retrieved.

Yeah ...

> But what I get back from the server is this packet:
> 0000   43 00 00 00 11 43 52 45 41 54 45 20 54 41 42 4c  C....CREATE TABL
> 0010   45 00                                            E.
> The query I sent to the server was:
> create table table1(i int)

CREATE TABLE and CREATE TABLE AS are two different things.

regression=# create table foo (x int);
CREATE TABLE

regression=# create table bar as select 1 as x;
SELECT 1

            regards, tom lane

Thanks for the clarification.

Maybe CREATE TABLE should be added as it's own line, since it's a distinct
case from the others in that table?

best regards
Alexander Kjäll
Den lör 28 apr. 2018 kl 23:01 skrev Tom Lane <tgl@sss.pgh.pa.us>:

> =?utf-8?q?PG_Doc_comments_form?= <noreply@postgresql.org> writes:
> > The documentation says:
> > For a SELECT or CREATE TABLE AS command, the tag is SELECT rows where
rows
> > is the number of rows retrieved.

> Yeah ...

> > But what I get back from the server is this packet:
> > 0000   43 00 00 00 11 43 52 45 41 54 45 20 54 41 42 4c  C....CREATE TABL
> > 0010   45 00                                            E.
> > The query I sent to the server was:
> > create table table1(i int)

> CREATE TABLE and CREATE TABLE AS are two different things.

> regression=# create table foo (x int);
> CREATE TABLE

> regression=# create table bar as select 1 as x;
> SELECT 1

>                          regards, tom lane