| From: | Amit Langote <amitlangote09(at)gmail(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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 14:45:53 |
| Message-ID: | CA+HiwqHz2AbSoZb8v6NzkPuwuoJF1Kzmq_A65aDoMxe3egJOkQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Thu, Apr 25, 2019 at 10:46 PM Alvaro Herrera
<alvherre(at)2ndquadrant(dot)com> wrote:
> 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.
Oops, will do. Thanks.
Regards,
Amit
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-04-25 18:24:41 | Re: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault) |
| Previous Message | Sergei Kornilov | 2019-04-25 14:20:17 | Re: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2019-04-25 14:51:24 | Re: Comment fix for renamed functions |
| Previous Message | Alvaro Herrera | 2019-04-25 14:35:46 | Re: pg_dump is broken for partition tablespaces |