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

Re: Bug #766: version difference creates problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pranav(at)babultech(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #766: version difference creates problem
Date: 2002-09-14 15:46:11
Message-ID: 27200.1032018371@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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-bugsDate: 2002-09-14 20:41:36
Subject: Bug #767: Bug when inserting in "bytea" column type
Previous:From: Peter EisentrautDate: 2002-09-14 13:53:49
Subject: Re: Bug #766: version difference creates problem

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