Re: [HACKERS] 6.4 and reserved word USER...

Didn't we make that change for v6.3.2? *raised eyebrow*

On Wed, 28 Oct 1998, Michael J Schout wrote:

> 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
> 

Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org