Re: Documentation for CommandComplete is incorrect for CREATE TABLE with server version 10.2
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: > =?utf-8?q?PG_Doc_comments_form?= 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: > > 43 00 00 00 11 43 52 45 41 54 45 20 54 41 42 4c CCREATE TABL > > 0010 45 00E. > > 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 TABLE with server version 10.2
=?utf-8?q?PG_Doc_comments_form?=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: > 43 00 00 00 11 43 52 45 41 54 45 20 54 41 42 4c CCREATE TABL > 0010 45 00E. > 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 TABLE with server version 10.2
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: > > 43 00 00 00 11 43 52 45 41 54 45 20 54 41 42 4c CCREATE TABL > 0010 45 00E. > > 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 Herrerahttps://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services