RE: BEFORE UPDATE trigger on postgres_fdw table not work
shohei.mochizuki@toshiba.co.jp
From: <shohei.mochizuki@toshiba.co.jp>
To: <etsuro.fujita@gmail.com>
Cc: <Langote_Amit_f8@lab.ntt.co.jp>, <tgl@sss.pgh.pa.us>,
<pgsql-hackers@postgresql.org>
Date: 2019-06-13T11:16:13Z
Lists: pgsql-hackers
Fujita-san, > From: Etsuro Fujita [mailto:etsuro.fujita@gmail.com] > > Mochizuki-san, > > On Wed, Jun 12, 2019 at 6:08 PM <shohei.mochizuki@toshiba.co.jp> wrote: > > > On Mon, Jun 10, 2019 at 9:04 PM Etsuro Fujita > > > <etsuro.fujita@gmail.com> > > > wrote: > > > > I'll look into the patch more closely tomorrow. > > > > > > I did that, but couldn't find any issue about the patch. Here is an > > > updated version of the patch. Changes are: > > > > > > * Reworded the comments a bit in postgresPlanFoereignModify the > > > original patch modified > > > * Added the commit message > > > I think your wording is more understandable than my original patch. > > Great! I've pushed the patch after updating the comment as proposed by > Amit-san yesterday, and adding a regression test case checking EXPLAIN > because otherwise we wouldn't have any EXPLAIN results in v9.4. > > Thanks for the report and fix! Thanks for the commit! -- Shohei Mochizuki
Commits
-
postgres_fdw: Account for triggers in non-direct remote UPDATE planning.
- 1a3d9f62c1d1 9.4.23 landed
- eddb79705f65 9.5.18 landed
- 1ade21e7facc 9.6.14 landed
- 0f2b234263ef 10.9 landed
- 214460182161 11.4 landed
- 8b6da83d162c 12.0 landed
-
Offer triggers on foreign tables.
- 7cbe57c34dec 9.4.0 cited