Date: Sat, 28 Apr 2018 17:49:56 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: alexander.kjall@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Documentation for CommandComplete is incorrect for CREATE TABLE
 with server version 10.2
Message-ID: <20180428204956.jgnnhh6xo24vsb33@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <152484514371.19805.1929006962334941488@wrigleys.postgresql.org>
User-Agent: NeoMutt/20170306-137-4415bd-dirty (1.8.0)
Precedence: bulk

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