Re: BUG #5315: Unlisted keyword WINDOW

sulfinu@gmail.com wrote:
> 
> The following bug has been logged online:
> 
> Bug reference:      5315
> Logged by:          
> Email address:      sulfinu@gmail.com
> PostgreSQL version: 8.4.2
> Operating system:   Gentoo Linux
> Description:        Unlisted keyword WINDOW
> Details: 
> 
> According to the official documentation
> (http://www.postgresql.org/docs/8.4/interactive/sql-keywords-appendix.html),
> the SQL reserved keyword WINDOW is totally uninteresting to PostgreSQL.
> 
> But in real life the parser has a different opinion. Just try this:
> create table a (
> window integer,
> c varchar(20));
> 
> So, either correct the parser (is there any use for the word WINDOW in
> Postgres?) or the documentation.

Ah, quite interesting.  I grabed all the keywords in our SGML docs
listed as somehow reserved in Postgres, and then ran "SELECT word FROM 
pg_get_keywords() WHERE catcode != 'U'" to get all the keywords from our
C code, and then compared the two.  The two missing keywords were OVER,
and WINDOW, as you mentioned.

I have applied the attached patch to CVS HEAD and 8.4.X to properly
document our keywords.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +