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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Tweak postgres_fdw regression test so autovacuum doesn't change
Дата
Msg-id E1UlpFL-00035k-Nx@gemulon.postgresql.org
обсуждение исходный текст
Список 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(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Remove unnecessary restrictions about RowExprs in transformAExpr
Следующее
От: Joe Conway
Дата:
Сообщение: pgsql: Fix ordering of obj id for Rules and EventTriggers in pg_dump.