Thread: Bug #766: version difference creates problem

Bug #766: version difference creates problem

From
pgsql-bugs@postgresql.org
Date:
Pranav Vora (pranav@babultech.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
version difference creates problem

Long Description
Hello,

I am using Postgres 6.5 on Redhat 6.2 and postgres 7.0 on Redhat 7.0/Mandrake 8.0 perfectly. And, I was running my web
applicationsince 1.5 years. 

Now, when I tried  to run my web application on Mandrake 8.1 with Postgres 7.1.2. It is the staring point of creating
problems.When I trace back the problem, I found that 'inout' is creating problem. 

I have a database table named 'inout'.So, from previous version I dumped database through pg_dump and created one .db
file.

Then I re-created on 7.1.2 through psql and then \i command. It was successfull. Then other tables were accessed
withoutpain.  

select * from inout; was giving parse error near or at 'inout'

Then I juggled with query and found that

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'tafford to change all the queries with table name change thoroughout the system. 

So, please, help me out as early as possible, because,it's a time management system so each day is important

waiting for your favourable reply...

Pranav

Sample Code


No file was uploaded with this report

Re: Bug #766: version difference creates problem

From
Peter Eisentraut
Date:
> select * from inout; was giving parse error near or at 'inout'
>
> Then I juggled with query and found that
>
> 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.

--
Peter Eisentraut   peter_e@gmx.net

Re: Bug #766: version difference creates problem

From
Tom Lane
Date:
Peter Eisentraut <peter_e@gmx.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