recent ECPG 7.1->7.2 incompatibility ( interval('0sec') = syntax error )

Поиск
Список
Период
Сортировка
От Christof Petig
Тема recent ECPG 7.1->7.2 incompatibility ( interval('0sec') = syntax error )
Дата
Msg-id 3BE27A1F.B762253F@petig-baender.de
обсуждение исходный текст
Ответы Re: recent ECPG 7.1->7.2 incompatibility ( interval('0sec') = syntax error )
Список pgsql-bugs
Hello,

while switching to the 7.2 ecpg on a 7.1 database for it's new features,
we recognized several incompatibilities:

date ( some_timestamp_var ),  timestamp ( something ), timestamp
(date_var, time_var ), interval('0sec')   are not longer possible.

I don't know whether these constructs are legal in a 7.2 database, but
we used them a lot in our code.

cast ( some_timestamp_var as date), '0sec'::interval   and   "timestamp"
(date_var, time_var)  still work but if this is just an oversight, I'd
recommend to fix it.

Yours
    Christof

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: user authentication crash by Erik Luke (20-08-2001; 1.3kb)
Следующее
От: Christof Petig
Дата:
Сообщение: Re: recent ECPG 7.1->7.2 incompatibility ( interval('0sec') = syntax