Re: COPY BINARY 8.3 to 8.4 timestamp incorrect

From: "Chase, John" <jchase(at)mtcsc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: COPY BINARY 8.3 to 8.4 timestamp incorrect
Date: 2009-10-14 14:28:47
Message-ID: FB8E264F6469914FA02A3B847B448D2C032FC6E0@MAIL.ITSFAC.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-10-14 14:29:56 Re: different sort order for primary key index
Previous Message Grzegorz Jaśkiewicz 2009-10-14 14:20:37 Re: COPY BINARY 8.3 to 8.4 timestamp incorrect