On Thu, 21 Oct 2021 at 23:10, Tom Lane <t...@sss.pgh.pa.us> wrote: > Japin Li <japi...@hotmail.com> writes: >> On Thu, 21 Oct 2021 at 22:46, Tom Lane <t...@sss.pgh.pa.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. >
Does that mean we should use the subscriber's settings to set the replication's parameter (e.g. datestyle)? If we do this, it might loss precision (for example: extra_float_digits on publisher is 3 and on subscriber is -4), is this accpted? -- Regrads, Japin Li. ChengDu WenWu Information Technology Co.,Ltd.
