BUG #14135: SQL command "analyse" is undocumented

Поиск
Список
Период
Сортировка
От ville@torhonen.fi
Тема BUG #14135: SQL command "analyse" is undocumented
Дата
Msg-id 20160512082409.2608.93471@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #14135: SQL command "analyse" is undocumented  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14135
Logged by:          Ville Törhönen
Email address:      ville@torhonen.fi
PostgreSQL version: 9.5.2
Operating system:   CentOS 6.5
Description:

Hello,

On PostgreSQL 9.5.2 SQL commands "analyze" and "analyse" run exactly the
same thing. However, the "analyse" command is completely undocumented.

postgres=# \h analyze
Command:     ANALYZE
Description: collect statistics about a database
Syntax:
ANALYZE [ VERBOSE ] [ table_name [ ( column_name [, ...] ) ] ]

postgres=# \h analyse
No help available for "analyse".
Try \h with no arguments to see available help.

Tab completion does not acknowledge "analyse" command. Product documentation
[1] states that the command "analyse" is reserved, but "Appendix C: SQL Key
Words" is the only page in the whole documentation that mentions the word
"analyse".

Tested with the following PostgreSQL RPM packages from PostgreSQL yum
repository (yum.postgresql.org):

postgresql95-libs-9.5.2-1PGDG.rhel6.x86_64
postgresql95-server-9.5.2-1PGDG.rhel6.x86_64
postgresql95-9.5.2-1PGDG.rhel6.x86_64
postgresql95-contrib-9.5.2-1PGDG.rhel6.x86_64
postgresql95-devel-9.5.2-1PGDG.rhel6.x86_64

Regards,
Ville

[1] http://www.postgresql.org/docs/9.5/static/sql-keywords-appendix.html

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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: BUG #14132: ON CONFLICT not inferring unique index with bigints
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #14135: SQL command "analyse" is undocumented