pgsql: Tweak postgres_fdw regression test so autovacuum doesn't change

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Tweak postgres_fdw regression test so autovacuum doesn't change
Date: 2013-06-09 23:42:03
Message-ID: E1UlpFL-00035k-Nx@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Tweak postgres_fdw regression test so autovacuum doesn't change results.

Autovacuum occurring while the test runs could allow some of the inserts to
go into recycled space, thus changing the output ordering of later queries.
While we could complicate those queries to force sorting of their output
rows, it doesn't seem like that would make the test better in any
meaningful way, and conceivably it could hide unexpected diffs. Instead,
tweak the affected queries so that the inserted rows aren't updated by the
following UPDATE. Per buildfarm.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/e0b451e43250558b3c1ac830e067b39e25e0e348

Modified Files
--------------
contrib/postgres_fdw/expected/postgres_fdw.out | 222 ++++++++++++------------
contrib/postgres_fdw/sql/postgres_fdw.sql | 6 +-
2 files changed, 113 insertions(+), 115 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Joe Conway 2013-06-10 00:32:23 pgsql: Fix ordering of obj id for Rules and EventTriggers in pg_dump.
Previous Message Tom Lane 2013-06-09 22:40:27 pgsql: Remove unnecessary restrictions about RowExprs in transformAExpr