| From: | Japin Li <japinli(at)hotmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Sadhuprasad Patro <b(dot)sadhu(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber |
| Date: | 2021-10-18 04:13:37 |
| Message-ID: | MEYP282MB16690E70E7FC3926BE52543DB6BC9@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, 18 Oct 2021 at 11:41, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-10-18 04:17:07 | Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber |
| Previous Message | Japin Li | 2021-10-18 04:10:34 | Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber |