| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Amit Langote <amitlangote09(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, jianingy(dot)yang(at)gmail(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: BUG #15672: PostgreSQL 11.1/11.2 crashed after dropping a partition table |
| Date: | 2019-04-25 13:46:23 |
| Message-ID: | 20190425134623.GA26586@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
Haven't read the patch, but I tried applying it on top of my tablespace
fixing patch ... and my first report is that this query in regress fails
(three times):
select conname, obj_description(oid, 'pg_constraint') from pg_constraint where conname = 'c_chk' order by 1, 2;
conname | obj_description
---------+---------------------------------------
+ c_chk | alttype_cleanup_idx check constraint
c_chk | alttype_cleanup_idx1 check constraint
c_chk | alttype_cleanup_idx2 check constraint
- c_chk | alttype_cleanup_idx check constraint
(3 rows)
I think you should use 'ORDER BY 2 COLLATE "C"' to avoid the problem.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-04-25 13:59:21 | Re: CREATE SUBSCRIPTION fails with long passwords |
| Previous Message | PG Bug reporting form | 2019-04-25 13:32:31 | BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-04-25 13:49:22 | Re: [Patch] Check file type before calling AllocateFile() for files out of pg data directory to avoid potential issues (e.g. hang). |
| Previous Message | PG Bug reporting form | 2019-04-25 13:32:31 | BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault) |