6.4 and reserved word USER...

From: Michael J Schout <mschout(at)gkg(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: 6.4 and reserved word USER...
Date: 1998-10-29 03:51:48
Message-ID: 3637E654.8110CD22@gkg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-10-29 03:54:06 Re: [HACKERS] Another bug in pg_operator.h
Previous Message Bruce Momjian 1998-10-29 03:37:24 Re: [HACKERS] Open 6.4 items