Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber

Поиск
Список
Период
Сортировка
От Japin Li
Тема Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber
Дата
Msg-id MEYP282MB16690E70E7FC3926BE52543DB6BC9@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Japin Li
Дата:
Сообщение: Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber