Re: COPY BINARY 8.3 to 8.4 timestamp incorrect

Wow, quick response from Dave Page. For those who may be interested,
here's his answer:

"pgInstaller used floating point, whilst the one-click installers use
(and will continue to use) the more accurate integer timestamps."

-----Original Message-----
From: Chase, John
Sent: Wednesday, October 14, 2009 10:29 AM
To: pgsql-general(at)postgresql(dot)org
Subject: RE: [GENERAL] COPY BINARY 8.3 to 8.4 timestamp incorrect

That makes sense, of course. I'm guessing this is because I formally
used the pgInstaller and since 8.4 is not supported yet by pgInstaller I
moved to the EnterpriseDB installer. The man behind the current must
have done the build with different options. Would you concur? Maybe I
should ask the man behind the curtain (Dave Page).

Thanks!

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, October 14, 2009 10:21 AM
To: Chase, John
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] COPY BINARY 8.3 to 8.4 timestamp incorrect

"Chase, John" <jchase(at)mtcsc(dot)com> writes:
> I am working on upgrading from 8.3.7 to 8.4.1. One of the functions of
> our application is to "export" and "import" data, and to accomplish
this
> I've written some functions that use COPY ... TO ... BINARY and COPY
...
> FROM ... BINARY. In testing the upgrade to 8.4.1 I noticed that when I
> "import" from export files that were created under 8.3.7 the
timestamps
> are not brought in correctly.

Probably you've got 8.4 compiled with integer timestamps where the 8.3
DB used float timestamps, or perhaps vice-versa.

regards, tom lane