Thread: Documentation for CommandComplete is incorrect for CREATE TABLE withserver version 10.2
Documentation for CommandComplete is incorrect for CREATE TABLE withserver version 10.2
From
PG Doc comments form
Date:
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)
Re: Documentation for CommandComplete is incorrect for CREATE TABLEwith server version 10.2
From
Alvaro Herrera
Date:
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
Re: Documentation for CommandComplete is incorrect for CREATE TABLE with server version 10.2
From
Tom Lane
Date:
=?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
Re: Documentation for CommandComplete is incorrect for CREATE TABLEwith server version 10.2
From
Alexander Kjäll
Date:
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