Re: COPY BINARY 8.3 to 8.4 timestamp incorrect

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chase, John" <jchase(at)mtcsc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY BINARY 8.3 to 8.4 timestamp incorrect
Date: 2009-10-14 14:20:33
Message-ID: 12771.1255530033@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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 Grzegorz Jaśkiewicz 2009-10-14 14:20:37 Re: COPY BINARY 8.3 to 8.4 timestamp incorrect
Previous Message Chase, John 2009-10-14 14:03:21 COPY BINARY 8.3 to 8.4 timestamp incorrect