Re: Syntax error and reserved keywords - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Syntax error and reserved keywords
Date
Msg-id 1331757050.22638.0.camel@vanquo.pezone.net
Whole thread Raw
In response to Syntax error and reserved keywords  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: Syntax error and reserved keywords  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List pgsql-hackers
On ons, 2012-03-14 at 14:58 +0100, Dimitri Fontaine wrote:
> A colleague came to me to express his surprise about this quite simple
> use case:
> 
>   =# alter table toto add column user text;
>   ERROR:  syntax error at or near "user"
>   LINE 1: alter table toto add column user text;
> 
> Is there a reason for us not to add an HINT: "user" is a reserved
> keyword or something like that, other than nobody having been interested
> in doing the work?

If that were easily possible, we could just recognize 'user' as an
identifier in this context and avoid the issue altogether.  But it's
not.



pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Faster compression, again
Next
From: Peter Eisentraut
Date:
Subject: Re: CREATE FOREGIN TABLE LACUNA