Re: Bug #545: Keyword USER not detected in CREATE VIEW

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: Bug #545: Keyword USER not detected in CREATE VIEW
Дата
Msg-id 3C2CDF25.5C7DC8C3@fourpalms.org
обсуждение исходный текст
Ответ на Bug #545: Keyword USER not detected in CREATE VIEW  (pgsql-bugs@postgresql.org)
Ответы Re: Bug #545: Keyword USER not detected in CREATE VIEW  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
> >   avi=> create view z as select x as user from y;
> > My expected result: an error message in CREATE VIEW
> This is not a bug, it is intentional behavior.  "AS" names are not
> restricted to be non-reserved words.

Sure, but his point is that the resulting view has a column which is
named "user" and which is not directly accessible without using double
quotes.

I'm not sure that would qualify as a bug, but certainly is a gotcha...

                      - Thomas

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bug #545: Keyword USER not detected in CREATE VIEW
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bug #545: Keyword USER not detected in CREATE VIEW