Re: BUG #15672: PostgreSQL 11.1/11.2 crashed after dropping a partition table

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

In response to

Responses

Browse pgsql-bugs by date

  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)

Browse pgsql-hackers by date

  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)