Hi all, While browsing the buildfarm failures, I have found this problem on anole for the test temp: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=anole&dt=2019-08-07%2006%3A39%3A35 select relname from pg_class where relname like 'temp_parted_oncommit_test%'; relname ---------------------------- - temp_parted_oncommit_test temp_parted_oncommit_test1 (2 rows)
drop table temp_parted_oncommit_test;
--- 276,283 ----
select relname from pg_class where relname like 'temp_parted_oncommit_test%';
relname
----------------------------
temp_parted_oncommit_test1
+ temp_parted_oncommit_test
(2 rows)
This could be solved just with an ORDER BY as per the attached. Any
objections?
Thanks,
--
Michael
diff --git a/src/test/regress/expected/temp.out b/src/test/regress/expected/temp.out
index eab75dbe2c..7538ca8ad6 100644
--- a/src/test/regress/expected/temp.out
+++ b/src/test/regress/expected/temp.out
@@ -273,7 +273,8 @@ select * from temp_parted_oncommit_test;
(1 row)
-- two relations remain in this case.
-select relname from pg_class where relname like 'temp_parted_oncommit_test%';
+select relname from pg_class where relname like 'temp_parted_oncommit_test%'
+ order by relname;
relname
----------------------------
temp_parted_oncommit_test
diff --git a/src/test/regress/sql/temp.sql b/src/test/regress/sql/temp.sql
index 761955bfe6..6158b5a3df 100644
--- a/src/test/regress/sql/temp.sql
+++ b/src/test/regress/sql/temp.sql
@@ -210,7 +210,8 @@ commit;
-- preserved.
select * from temp_parted_oncommit_test;
-- two relations remain in this case.
-select relname from pg_class where relname like 'temp_parted_oncommit_test%';
+select relname from pg_class where relname like 'temp_parted_oncommit_test%'
+ order by relname;
drop table temp_parted_oncommit_test;
-- Check dependencies between ON COMMIT actions with inheritance trees.
signature.asc
Description: PGP signature
