Re: Schema in trigger in logical replication

2021-03-04 Thread Tom Lane
Adrian Klaver writes: > On 3/3/21 3:58 PM, Fontana Daniel C. (Desartec S.R.L.) wrote: >> When the update is manual, it works. >> It does not work when the update is done using logical replication. >> It is as if the logical replication wizard did not use the search_path > Replication would imply

Re: Schema in trigger in logical replication

2021-03-04 Thread Adrian Klaver
o: Re: Schema in trigger in logical replication On 3/3/21 2:35 PM, Fontana Daniel C. (Desartec S.R.L.) wrote: Using postgres 12.5 in DBA schema, this trigger is executed when the table is updated through a logical replication. Why is it necessary to name the schema for it to work? Becaus

Re: Schema in trigger in logical replication

2021-03-03 Thread Adrian Klaver
On 3/3/21 2:35 PM, Fontana Daniel C. (Desartec S.R.L.) wrote: Using postgres 12.5 in DBA schema, this trigger is executed when the table is updated through a logical replication. Why is it necessary to name the schema for it to work? Because the search_path does include the schema? When I upd