Re: BEFORE UPDATE trigger on postgres_fdw table not work

2019-05-27 Thread Shohei Mochizuki
On 2019/05/28 12:54, Amit Langote wrote: On 2019/05/27 22:02, Tom Lane wrote: Amit Langote writes: On 2019/05/27 10:52, Shohei Mochizuki wrote: I noticed returning a modified record in a row-level BEFORE UPDATE trigger on postgres_fdw foreign tables do not work. Attached patch fixes this

BEFORE UPDATE trigger on postgres_fdw table not work

2019-05-26 Thread Shohei Mochizuki
dd only columns modified in trigger to the target list of a remote update query, but I cannot find simple way to do that because update query is built during planning phase at postgresPlanForeignModify while it is difficult to decide which columns are modified by a trigger until query execution. Rega