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
Дата
Msg-id 1493997.1634528495@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber  (Michael Paquier <michael@paquier.xyz>)
Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber  (Japin Li <japinli@hotmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Added schema level support for publication.