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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Japin Li <japinli(at)hotmail(dot)com>
Cc: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Sadhuprasad Patro <b(dot)sadhu(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber
Date: 2021-10-21 15:10:36
Message-ID: 2409504.1634829036@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Japin Li <japinli(at)hotmail(dot)com> writes:
> On Thu, 21 Oct 2021 at 22:46, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> There's another issue here: the subscriber can run user-defined code
>> (in triggers), while AFAIK the sender cannot.

> Sorry, I'm not sure about this. Could you give me an example?

If you're doing logical replication into a table that has triggers,
the replication worker has to execute those triggers.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Japin Li 2021-10-21 15:32:46 Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber
Previous Message Japin Li 2021-10-21 15:04:12 Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber