Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15304: Problem when replicating Floating point timestampsto int64 timestamps - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #15304: Problem when replicating Floating point timestampsto int64 timestamps
Date
Msg-id 20180727174021.n2r3cweflwn3ip4j@alvherre.pgsql
Whole thread Raw
In response to BUG #15304: Problem when replicating Floating point timestamps toint64 timestamps  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15304: Problem when replicating Floating point timestamps toint64 timestamps  (Vasilis Ventirozos <v.ventirozos@gmail.com>)
List pgsql-bugs
Tree view 
On 2018-Jul-27, PG Bug reporting form wrote:

> While testing a migration procedure on a database (v9.6.9) from floating
> point datetimes to int64 (v9.6.9) using pglogical i saw that after the
> initial data sync all the subsequent replicated rows containing dates are
> getting nonsensical datetime values in the subscriber. 
> I've read:
> https://www.postgresql.org/message-id/flat/26788.1487455319%40sss.pgh.pa.us#26788.1487455319@sss.pgh.pa.us
> So I know that this is not something new, but i was wondering if there is
> any way around this,

As I recall, pglogical has a way to indicate transmission of data using
the text representation rather than binary, which should fix this
problem.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15304: Problem when replicating Floating point timestamps toint64 timestamps
Next
From: Vasilis Ventirozos
Date:
Subject: Re: BUG #15304: Problem when replicating Floating point timestamps toint64 timestamps