6.4 and reserved word USER...

Поиск
Список
Период
Сортировка
От Michael J Schout
Тема 6.4 and reserved word USER...
Дата
Msg-id 3637E654.8110CD22@gkg.net
обсуждение исходный текст
Ответы Re: [HACKERS] 6.4 and reserved word USER...
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Open 6.4 items
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Another bug in pg_operator.h