Re: integer_datetime: 8.2/8.4 differences ?

"fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com> writes:
> I updated the server from 8.2 to 8.4, but I am still using
> libpq 8.2 to write timestamps with the libpq C interface,
> using the binary format and PQexecParams(). While pgAdmin in
> 8.2 server shows correct timestamps, 8.4 displays garbage
> (year 15000 etc).

> This has probably to do with the compile time option
> integer_datetime -- however, did anything change? I could
> not find anything in the changelogs.

The first item listed under "Observe the following incompatibilities"
in the 8.4 release notes is

Use 64-bit integer datetimes by default (Neil Conway)

Previously this was selected by configure's
--enable-integer-datetimes option. To retain the old behavior,
build with --disable-integer-datetimes.

regards, tom lane