Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group