"fkater@xxxxxxxxxxxxxx" <fkater@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
