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.
pgsql-bugs by date
|Next:||From: Michael Meskes||Date: 2001-11-02 15:20:46|
|Subject: Re: recent ECPG 7.1->7.2 incompatibility ( interval('0sec') = syntax error )|
|Previous:||From: Tom Lane||Date: 2001-11-01 18:45:05|
|Subject: Re: Union View Optimization |