Re: Documentation for CommandComplete is incorrect for CREATE TABLEwith server version 10.2

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Documentation for CommandComplete is incorrect for CREATE TABLEwith server version 10.2
Дата
Msg-id 20180428204956.jgnnhh6xo24vsb33@alvherre.pgsql
обсуждение исходный текст
Ответ на Documentation for CommandComplete is incorrect for CREATE TABLE withserver version 10.2  (PG Doc comments form <noreply@postgresql.org>)
Список pgsql-docs
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


В списке pgsql-docs по дате отправления:

Предыдущее
От: Jürgen Purtz
Дата:
Сообщение: Re: Appendix A. PostgreSQL Error Codes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Documentation for CommandComplete is incorrect for CREATE TABLE with server version 10.2