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

From Tom Lane
Subject Re: BUG #2598: Columns named R are not accessible - although R is not a keyword
Date
Msg-id 28061.1156951511@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2598: Columns named R are not accessible - although R is not a keyword  ("Andreas Langegger" <al@jku.at>)
Responses Re: BUG #2598: Columns named R are not accessible - although  (Andreas Langegger <al@jku.at>)
List 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 by date:

Previous
From: "Andreas Langegger"
Date:
Subject: BUG #2598: Columns named R are not accessible - although R is not a keyword
Next
From: Tom Lane
Date:
Subject: Re: BUG #2598: Columns named R are not accessible - although R is not a keyword