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