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

From Japin Li
Subject Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber
Date
Msg-id MEYP282MB16690E70E7FC3926BE52543DB6BC9@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM
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>)
List pgsql-hackers
On Mon, 18 Oct 2021 at 11:41, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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.
>

Thanks for your remention.  As Michael Paquier side, dblink also uses the
similar logical.  I will read them then update the patch.

-- 
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.



pgsql-hackers by date:

Previous
From: Japin Li
Date:
Subject: Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber
Next
From: Tom Lane
Date:
Subject: Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber