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

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 wanting to
Date: 2010-10-22 14:47:08
Message-ID: E1P9Itg-0003oU-B9@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
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(-)

Browse pgsql-committers by date

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