6.4 and reserved word USER... - Mailing list pgsql-hackers

From Michael J Schout
Subject 6.4 and reserved word USER...
Date
Msg-id 3637E654.8110CD22@gkg.net
Whole thread Raw
Responses Re: [HACKERS] 6.4 and reserved word USER...  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
Hi.

I have not followed hackers regularly, so im sure this has probably been 
asked before.  Anyways, I tried the 6.4 beta 3 today, and noticed that
the
word "USER" has been reserved now.  Since I have an app that uses a
column
named "user" I went into backend/parser/gram.y and added a line like:
    | USER          { $$ = "user" }

into that file so that USER would be accepted.

However, I noticed that this breaks a lot of queries :).  Apparently
doing a
"SELECT user" now returns your username.  So in order to make my queries
work
I would have to do "SELECT table.user FROM table....".  If there is no
other
way around it, Ill probably just have to rename the colunm and track
down all
references to it in my application (ugh :().  

SO my question is this:  Is there anything else that could  be done to
make
this work?  Or will we break the "SELECT USER" usefulness by doing
something 
like this?  Im guessing its probably not going to be possible :)  But
though
I would ask those a little more familiar with the source tree than me
since
I just started looking at at now :)

Mike


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Open 6.4 items
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Another bug in pg_operator.h