regression.diff.txt

text/plain

Filename: regression.diff.txt
Type: text/plain
Part: 0
Message: Re: speeding up planning with partitions
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)