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

From: Sadhuprasad Patro <b(dot)sadhu(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Fwd: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber
Date: 2021-10-14 10:18:22
Message-ID: CAFF0-CF=D7pc6st-3A9f1JnOt0qmc+BcBPVzD6fLYisKyAjkGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi All,

Publisher 'DateStyle' is set as "SQL, MDY", whereas in Subscriber as
"SQL, DMY", the logical replication is not working...

From Publisher:
postgres=# INSERT INTO calendar VALUES ('07-18-1036', '1'), ('05-15-1135', '1');
INSERT 0 2

Getting below error in the subscriber log file,
2021-10-14 00:59:23.067 PDT [38262] ERROR: date/time field value out
of range: "07/18/1036"
2021-10-14 00:59:23.067 PDT [38262] HINT: Perhaps you need a
different "datestyle" setting.

Is this an expected behavior?

Thanks & Regards
SadhuPrasad
http://www.EnterpriseDB.com/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2021-10-14 10:59:06 Re: Added schema level support for publication.
Previous Message 蔡梦娟 (玊于) 2021-10-14 10:03:06 Some doubts about streaming startpoint in WaitForWALToBecomeAvailable()