BUG #14135: SQL command "analyse" is undocumented

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

Responses

Browse pgsql-bugs by date

  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