]> granicus.if.org Git - postgresql/commit
Tweak postgres_fdw regression test so autovacuum doesn't change results.
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Jun 2013 23:41:52 +0000 (19:41 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Jun 2013 23:41:52 +0000 (19:41 -0400)
commite0b451e43250558b3c1ac830e067b39e25e0e348
tree781d418bf6355776972b1d8841fa5929770af12f
parenta4424c57c3da52efa212b21521abff4bf129b19e
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.
contrib/postgres_fdw/expected/postgres_fdw.out
contrib/postgres_fdw/sql/postgres_fdw.sql