Re: BUG #2598: Columns named R are not accessible - although R is not a keyword

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #2598: Columns named R are not accessible - although R is not a keyword
Дата
Msg-id 28061.1156951511@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #2598: Columns named R are not accessible - although R is not a keyword  ("Andreas Langegger" <al@jku.at>)
Ответы Re: BUG #2598: Columns named R are not accessible - although
Список pgsql-bugs
"Andreas Langegger" <al@jku.at> writes:
> It seems that the column name "R" or "r" is reserved.

Hardly.

> If I want to insert tuples I get the error message:

> ERROR:  column "r" of relation "xyz" does not exist

Worksforme:

regression=# create table xyz(r int);
CREATE TABLE
regression=# insert into xyz(r) values(42);
INSERT 0 1

Perhaps you could provide a self-contained test case?

            regards, tom lane

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

Предыдущее
От: "Andreas Langegger"
Дата:
Сообщение: BUG #2598: Columns named R are not accessible - although R is not a keyword
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #2598: Columns named R are not accessible - although R is not a keyword