Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber
Date
Msg-id 1493997.1634528495@sss.pgh.pa.us
Whole thread Raw
In response to Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber
Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber
List pgsql-hackers
I wrote:
> An alternative that wouldn't require a network round trip is for the
> publisher to set its own datestyle to ISO/YMD.  I'm pretty sure that
> will be interpreted correctly regardless of the receiver's datestyle.

Ah ... see postgres_fdw's set_transmission_modes().  I think we want
to copy that logic not invent some other way to do it.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber
Next
From: Amit Kapila
Date:
Subject: Re: Added schema level support for publication.