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

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

From: "Andreas Langegger" <al(at)jku(dot)at>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2598: Columns named R are not accessible - although R is not a keyword
Date: 2006-08-29 21:47:55
Message-ID: 200608292147.k7TLlti3007373@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Charlie SavageDate: 2006-08-29 23:13:40
Subject: Re: BUG #2594: Gin Indexes cause server to crash on Windows
Previous:From: DavidDate: 2006-08-29 19:13:50
Subject: BUG #2597: windows installer error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group