Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fCWy7-0007si-7j for pgsql-docs@arkaria.postgresql.org; Sat, 28 Apr 2018 21:01:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fCWy6-0000P1-1C for pgsql-docs@arkaria.postgresql.org; Sat, 28 Apr 2018 21:01:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fCWy5-0000Os-Rt for pgsql-docs@lists.postgresql.org; Sat, 28 Apr 2018 21:01:17 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fCWxz-0006gH-2T for pgsql-docs@lists.postgresql.org; Sat, 28 Apr 2018 21:01:17 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id w3SL18vd003274; Sat, 28 Apr 2018 17:01:08 -0400 From: Tom Lane To: alexander.kjall@gmail.com cc: pgsql-docs@lists.postgresql.org Subject: Re: Documentation for CommandComplete is incorrect for CREATE TABLE with server version 10.2 In-reply-to: <152484514371.19805.1929006962334941488@wrigleys.postgresql.org> References: <152484514371.19805.1929006962334941488@wrigleys.postgresql.org> Comments: In-reply-to =?utf-8?q?PG_Doc_comments_form?= message dated "Fri, 27 Apr 2018 16:05:43 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <3272.1524949268.1@sss.pgh.pa.us> Date: Sat, 28 Apr 2018 17:01:08 -0400 Message-ID: <3273.1524949268@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk =?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: > 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