Re: Bug #766: version difference creates problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bug #766: version difference creates problem
Дата
Msg-id 27200.1032018371@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bug #766: version difference creates problem  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-bugs
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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Bug #766: version difference creates problem
Следующее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Bug #767: Bug when inserting in "bytea" column type