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

Japin Li <japinli@hotmail.com> writes:
> On Thu, 21 Oct 2021 at 19:54, Masahiko Sawada <sawada.mshk@gmail.com> wrote:
>> BTW I think we can set the parameters from the subscriber side without
>> additional network round trips by specifying the "options" parameter
>> in the connection string, no?

> Yes, we can.  However, each client should be concerned the style for
> datestyle, IMO it is boring.

There's another issue here: the subscriber can run user-defined code
(in triggers), while AFAIK the sender cannot.  People might be surprised
if their triggers run with a datestyle setting different from the
database's prevailing setting.  So while I think it should be okay
to set-and-forget the datestyle on the sender side, we could not get
away with that in the subscriber.  We'd have to set and unset for
each row, much as (e.g.) postgres_fdw has to do.

            regards, tom lane