Search Postgresql Archives

Re: Need help in transferring FP to Int64 DateTime

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux