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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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