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

Поиск
Список
Период
Сортировка
От Alexander Kjäll
Тема Re: Documentation for CommandComplete is incorrect for CREATE TABLEwith server version 10.2
Дата
Msg-id CAOuTi9U5Px5dqbH_dTZU9f5WM9jZX1qzxuPZYUXpwSZuJZ1-sQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Documentation for CommandComplete is incorrect for CREATE TABLE with server version 10.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-docs
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


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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Isn't "publication" wrongly defined here?
Следующее
От: "Jonathan S. Katz"
Дата:
Сообщение: Re: Appendix A. PostgreSQL Error Codes