diff -U3 /home/jpedersen/PostgreSQL/postgresql/contrib/postgres_fdw/expected/postgres_fdw.out /home/jpedersen/PostgreSQL/postgresql/contrib/postgres_fdw/results/postgres_fdw.out --- /home/jpedersen/PostgreSQL/postgresql/contrib/postgres_fdw/expected/postgres_fdw.out 2019-03-12 07:46:08.430690229 -0400 +++ /home/jpedersen/PostgreSQL/postgresql/contrib/postgres_fdw/results/postgres_fdw.out 2019-03-12 07:59:01.134285159 -0400 @@ -7190,8 +7190,8 @@ -- Check UPDATE with inherited target and an inherited source table explain (verbose, costs off) update bar set f2 = f2 + 100 where f1 in (select f1 from foo); - QUERY PLAN ---------------------------------------------------------------------------------------------- + QUERY PLAN +--------------------------------------------------------------------------------------- Update on public.bar Update on public.bar Foreign Update on public.bar2 @@ -7214,22 +7214,22 @@ Output: foo2.f1, foo2.ctid, foo2.*, foo2.tableoid Remote SQL: SELECT f1, f2, f3, ctid FROM public.loct1 -> Hash Join - Output: bar2.f1, (bar2.f2 + 100), bar2.f3, bar2.ctid, foo.ctid, foo.*, foo.tableoid + Output: bar2.f1, (bar2.f2 + 100), bar2.f3, bar2.ctid, foo.ctid, foo.* Inner Unique: true Hash Cond: (bar2.f1 = foo.f1) -> Foreign Scan on public.bar2 Output: bar2.f1, bar2.f2, bar2.f3, bar2.ctid Remote SQL: SELECT f1, f2, f3, ctid FROM public.loct2 FOR UPDATE -> Hash - Output: foo.f1, foo.ctid, foo.*, foo.tableoid + Output: foo.f1, foo.ctid, foo.* -> HashAggregate - Output: foo.f1, foo.ctid, foo.*, foo.tableoid + Output: foo.f1, foo.ctid, foo.* Group Key: foo.f1 -> Append -> Seq Scan on public.foo - Output: foo.f1, foo.ctid, foo.*, foo.tableoid + Output: foo.f1, foo.ctid, foo.* -> Foreign Scan on public.foo2 - Output: foo2.f1, foo2.ctid, foo2.*, foo2.tableoid + Output: foo2.f1, foo2.ctid, foo2.* Remote SQL: SELECT f1, f2, f3, ctid FROM public.loct1 (39 rows)