Re: Need help in transferring FP to Int64 DateTime - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Need help in transferring FP to Int64 DateTime
Date
Msg-id 4FD10BBD.8000706@gmail.com
Whole thread Raw
In response to Re: Need help in transferring FP to Int64 DateTime  (Benson Jin <benson.jin@troo.com>)
List pgsql-general
On 06/07/2012 08:29 AM, Benson Jin wrote:
> Hi Adrian,
>
> Thanks for the suggestion! We thought about that too, but concerned about the possible performance
penalty trigger based replication would bring. If there is no other
alternative, we will give
your suggestion a try...

AFAIK there is no direct way to do a binary fp timestamp --> integer
timestamp conversion, otherwise pg_upgrade would handle it. To make that
jump it needs to go through a text based representation. That leaves a
dump/restore cycle or non-binary replication.

>
> Cheers,
>
> Benson
>


--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Problem while restoring a database from SQL_ASCII to UTF-8
Next
From: Philipp Kraus
Date:
Subject: Re: acessibility for tables