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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andreas Langegger" <al(at)jku(dot)at>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2598: Columns named R are not accessible - although R is not a keyword
Date: 2006-08-30 15:25:11
Message-ID: 28061.1156951511@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Andreas Langegger" <al(at)jku(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Andreas LangeggerDate: 2006-08-30 15:35:44
Subject: Re: BUG #2598: Columns named R are not accessible - although
Previous:From: Filip HrbekDate: 2006-08-30 12:43:19
Subject: Re: Partially corrupted table

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