Bug #766: version difference creates problem

От:

pgsql-bugs@postgresql.org

Дата:

14 сентября 2002 г. в 09:02:34

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 application since 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 without pain. 

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.

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

От:

Tom Lane <tgl@sss.pgh.pa.us>

Дата:

14 сентября 2002 г. в 11:46:35

Peter Eisentraut  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

Re: Bug #766: version difference creates problem

От:

Peter Eisentraut <peter_e@gmx.net>

Дата:

14 сентября 2002 г. в 09:48:52

> 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