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 по дате отправления: