Re: BUG #15437: Segfault during insert into declarative partitionedtable with a trigger creating partition - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #15437: Segfault during insert into declarative partitionedtable with a trigger creating partition
Date
Msg-id 20181029024459.GD14242@paquier.xyz
Whole thread Raw
In response to Re: BUG #15437: Segfault during insert into declarative partitionedtable with a trigger creating partition  (Dmitry Shalashov <skaurus@gmail.com>)
Responses Re: BUG #15437: Segfault during insert into declarative partitionedtable with a trigger creating partition  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
List pgsql-bugs
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.
You could also look at something like pg_partman:
https://github.com/pgpartman/pg_partman
--
Michael

Attachment

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #15114: logical decoding Segmentation fault
Next
From: Michael Paquier
Date:
Subject: Re: BUG #15437: Segfault during insert into declarative partitionedtable with a trigger creating partition