The following bug has been logged online:

Bug reference: 2598
Logged by: Andreas Langegger
Email address: al (AT) jku (DOT) at
PostgreSQL version: 8.1
Operating system: Gentoo Linux 3.3.6, Kernel 2.6.16
Description: Columns named R are not accessible - although R is not a
keyword
Details:

It seems that the column name "R" or "r" is reserved. If I want to insert
tuples I get the error message:

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

And if I alter the column name to "a" it works. Again, renaming to "R" or
"r", same error. But it's not announced to be a name conflict / reserved
keyword...

Regards,
Andy

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

"Andreas Langegger" <al (AT) jku (DOT) at> writes:
Hardly.

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Andreas Langegger <al (AT) jku (DOT) at> writes:
"R" with double quotes represents capital R, but when you write R
without quotes in a query, it's implicitly downcased. See
http://www.postgresql.org/docs/8.1/s...AX-IDENTIFIERS

If you spell it like that in the table definition then you'll need
to use quotes every time you refer to the column, too.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match