| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Regression test failure in regression test temp.sql |
| Date: | 2019-08-07 13:24:22 |
| Message-ID: | 20190807132422.GC15695@paquier.xyz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| Attachment | Content-Type | Size |
|---|---|---|
| temp-partition-test.patch | text/x-diff | 1.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2019-08-07 13:30:46 | Re: stress test for parallel workers |
| Previous Message | Alexander Korotkov | 2019-08-07 13:11:44 | Re: SQL/JSON path: collation for comparisons, minor typos in docs |