Skip site navigation (1) Skip section navigation (2)

pgsql: Make OFF keyword unreserved. It's not hard to imagine wantingto

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Make OFF keyword unreserved. It's not hard to imagine wantingto
Date: 2010-10-22 14:47:08
Message-ID: E1P9Itg-0003oU-B9@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Make OFF keyword unreserved. It's not hard to imagine wanting to use 'off'
as a variable or column name, and it's not reserved in recent versions of
the SQL spec either. This became particularly annoying in 9.0, before that
PL/pgSQL replaced variable names in queries with parameter markers, so
it was possible to use OFF and many other backend parser keywords as
variable names. Because of that, backpatch to 9.0.

Branch
------
REL9_0_STABLE

Details
-------
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=143b8cbceec0d15dd5c747e2c45a4b0a762af6f0

Modified Files
--------------
src/backend/parser/gram.y   |   26 +++++++++++++-------------
src/include/parser/kwlist.h |    2 +-
2 files changed, 14 insertions(+), 14 deletions(-)

pgsql-committers by date

Next:From: Tom LaneDate: 2010-10-22 15:10:28
Subject: Re: pgsql: Make OFF keyword unreserved. It's not hard to imagine wanting to
Previous:From: Tom LaneDate: 2010-10-22 02:19:07
Subject: Re: pgsql: Fix ecpg test building process to not generate *.dSYM junk on Ma

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group