Fix intermittent self-test failures caused by the stats_ext test.

Dean Rasheed <dean.a.rasheed@gmail.com>

Commit: 5576cbc8ff1f8b34e519e54ef43de68ed1b2f93e
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2019-09-15T12:16:59Z
Releases: 12.0
Fix intermittent self-test failures caused by the stats_ext test.

Commit d7f8d26d9 added new tests to the stats_ext regression test that
included creating a view in the public schema, without realising that
the stats_ext test runs in the same parallel group as the rules test,
which makes doing that unsafe.

This led to intermittent failures of the rules test on the buildfarm,
although I wasn't able to reproduce that locally. Fix by creating the
view in a different schema.

Tomas Vondra and Dean Rasheed, report and diagnosis by Thomas Munro.

Discussion: https://postgr.es/m/CA+hUKGKX9hFZrYA7rQzAMRE07L4hziCc-nO_b3taJpiuKyLLxg@mail.gmail.com

Files

PathChange+/−
src/test/regress/expected/stats_ext.out modified +23 −19
src/test/regress/sql/stats_ext.sql modified +21 −19

Discussion