Re: Syntax error and reserved keywords

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: Syntax error and reserved keywords
Дата
Msg-id
1331757050.22638.0.camel@vanquo.pezone.net
Ответ на
Список
Дерево обсуждения
Syntax error and reserved keywords Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: Syntax error and reserved keywords Peter Eisentraut <peter_e@gmx.net>
Re: Syntax error and reserved keywords Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: Syntax error and reserved keywords Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Syntax error and reserved keywords Tom Lane <tgl@sss.pgh.pa.us>
Re: Syntax error and reserved keywords Euler Taveira <euler@timbira.com>
Re: Syntax error and reserved keywords Pavel Stehule <pavel.stehule@gmail.com>
Re: Syntax error and reserved keywords Pavel Stehule <pavel.stehule@gmail.com>
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 по дате отправления
От: Merlin Moncure
Дата:
Сообщение: Re: Faster compression, again
От: Peter Eisentraut
Дата:
FAQ