Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas Langegger
Subject BUG #2598: Columns named R are not accessible - although R is not a keyword
Date
Msg-id 200608292147.k7TLlti3007373@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #2598: Columns named R are not accessible - although R is not a keyword  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      2598
Logged by:          Andreas Langegger
Email address:      al@jku.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

pgsql-bugs by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: BUG #2594: Gin Indexes cause server to crash on Windows
Next
From: Tom Lane
Date:
Subject: Re: BUG #2598: Columns named R are not accessible - although R is not a keyword