diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-03-26 11:45:58 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-03-26 11:46:04 -0300 |
| commit | 186b6df2e62251e5e1f3cae8a3257c7226f4188c (patch) | |
| tree | ae5a8cbd4526133b74dbd74990d0e0313ebe240f | |
| parent | 555ee77a9668e3f1b03307055b5027e13bf1a715 (diff) | |
| download | postgresql-186b6df2e62251e5e1f3cae8a3257c7226f4188c.tar.gz postgresql-186b6df2e62251e5e1f3cae8a3257c7226f4188c.zip | |
Fix test impredictability
Test 'triggers' fails when another one creates triggers concurrently at
some precise time, because of a missing WHERE clause.
Per buildfarm members snapper, desmoxytes.
| -rw-r--r-- | src/test/regress/expected/triggers.out | 1 | ||||
| -rw-r--r-- | src/test/regress/sql/triggers.sql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/src/test/regress/expected/triggers.out b/src/test/regress/expected/triggers.out index f534d0db18b..387e40d67d4 100644 --- a/src/test/regress/expected/triggers.out +++ b/src/test/regress/expected/triggers.out @@ -2199,6 +2199,7 @@ alter table parted_trigger attach partition parted_trigger_3 for values from (20 select tgname, conname, t.tgrelid::regclass, t.tgconstrrelid::regclass, c.conrelid::regclass, c.confrelid::regclass from pg_trigger t join pg_constraint c on (t.tgconstraint = c.oid) + where tgname = 'parted_trigger' order by t.tgrelid::regclass::text; tgname | conname | tgrelid | tgconstrrelid | conrelid | confrelid ----------------+----------------+--------------------+-------------------+--------------------+----------- diff --git a/src/test/regress/sql/triggers.sql b/src/test/regress/sql/triggers.sql index 9d3e0ef7079..c6f31dd8c8f 100644 --- a/src/test/regress/sql/triggers.sql +++ b/src/test/regress/sql/triggers.sql @@ -1555,6 +1555,7 @@ alter table parted_trigger attach partition parted_trigger_3 for values from (20 select tgname, conname, t.tgrelid::regclass, t.tgconstrrelid::regclass, c.conrelid::regclass, c.confrelid::regclass from pg_trigger t join pg_constraint c on (t.tgconstraint = c.oid) + where tgname = 'parted_trigger' order by t.tgrelid::regclass::text; drop table parted_referenced, parted_trigger, unparted_trigger; |