From: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
---|---|
To: | Michael Paquier <michael(at)paquier(dot)xyz>, Dmitry Shalashov <skaurus(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15437: Segfault during insert into declarative partitioned table with a trigger creating partition |
Date: | 2018-10-29 05:15:06 |
Message-ID: | 5d9c4f7a-52aa-a8bb-9a52-e93118f56a40@lab.ntt.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 2018/10/29 11:44, Michael Paquier wrote:
> On Fri, Oct 19, 2018 at 12:38:09PM +0300, Dmitry Shalashov wrote:
>> That may be off-topic here, but I feel that *some* way of auto-creating
>> partitions would be useful though. Maybe all partitioning setup could
>> boil down to one table declaration, with auto-created partitions of
>> the same structure, including indices and stuff.
>
> Some patches have been proposed for this purpose during v11 development
> timeline if I recall correctly, but they did not cross the finish line.
Hmm, I don't recall any, but maybe I missed some thread.
> You could also look at something like pg_partman:
> https://github.com/pgpartman/pg_partman
I haven't looked at how pg_partman does it, but I suspect it's not doing
it inside a trigger or we would've heard of this crash from pg_partman's
developers. :) I don't hear you saying it does, but just thought I'd
mention it.
Thanks,
Amit
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Langote | 2018-10-29 05:28:53 | Re: BUG #15437: Segfault during insert into declarative partitioned table with a trigger creating partition |
Previous Message | Michael Paquier | 2018-10-29 03:31:17 | Re: BUG #15437: Segfault during insert into declarative partitioned table with a trigger creating partition |