Fix intermittent self-test failures caused by the stats_ext test.
Dean Rasheed <dean.a.rasheed@gmail.com>
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
| Path | Change | +/− |
|---|---|---|
| src/test/regress/expected/stats_ext.out | modified | +23 −19 |
| src/test/regress/sql/stats_ext.sql | modified | +21 −19 |
Discussion
- BF failure: could not open relation with OID XXXX while querying pg_views 12 messages · 2019-08-13 → 2019-09-15