On Mon, Oct 18, 2021 at 1:41 PM Japin Li <japi...@hotmail.com> wrote:
> I attached v3 patch that set IntervalStyle to 'postgres' when the > server backend is walsender, and this problem has gone. > I test that set IntervalStyle to 'sql_standard' on publisher and > 'iso_8601' on subscriber, it works fine. > Please try v3 patch and let me know if they work as unexpected. > Thanks in advance. I think the idea of setting the standard DateStyle and the IntervalStyle on the walsender process looks fine to me. As this will avoid extra network round trips as Tom mentioned. -- Regards, Dilip Kumar EnterpriseDB: http://www.enterprisedb.com