Fix intermittent self-test failures caused by the stats_ext test.
authorDean Rasheed <dean.a.rasheed@gmail.com>
Sun, 15 Sep 2019 12:16:59 +0000 (13:16 +0100)
committerDean Rasheed <dean.a.rasheed@gmail.com>
Sun, 15 Sep 2019 12:16:59 +0000 (13:16 +0100)
commit5576cbc8ff1f8b34e519e54ef43de68ed1b2f93e
treee5fd1c0a74b2efae5976b164d650d90b19c1713c
parent1c6b62a7d0e57bf9ac7a91d47484b1ea9f2857cd
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
src/test/regress/expected/stats_ext.out
src/test/regress/sql/stats_ext.sql