From: | ville(at)torhonen(dot)fi |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14135: SQL command "analyse" is undocumented |
Date: | 2016-05-12 08:24:09 |
Message-ID: | 20160512082409.2608.93471@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14135
Logged by: Ville Törhönen
Email address: ville(at)torhonen(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-05-12 14:05:42 | Re: BUG #14135: SQL command "analyse" is undocumented |
Previous Message | Peter Geoghegan | 2016-05-11 20:36:16 | Re: BUG #14132: ON CONFLICT not inferring unique index with bigints |