Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
>> select * from "inout" is working. but, such thing can not be done in my
>> web application as it is a java code and I can't afford to change all
>> the queries with table name change thoroughout the system.
> You're going to have to or be stuck with old versions forever.
Actually, it looks like "inout" is an unreserved keyword as of 7.2,
so his real mistake was not upgrading far enough ;-)
In general though, using words that are stated to be reserved by SQL99
as column or table names is a recipe for trouble in the long term...
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: pgsql-bugs||Date: 2002-09-14 20:41:36|
|Subject: Bug #767: Bug when inserting in "bytea" column type|
|Previous:||From: Peter Eisentraut||Date: 2002-09-14 13:53:49|
|Subject: Re: Bug #766: version difference creates problem|