Re: BUG #15437: Segfault during insert into declarative partitioned table with a trigger creating partition
Michael Paquier <michael@paquier.xyz>
From: Michael Paquier <michael@paquier.xyz>
To: Dmitry Shalashov <skaurus@gmail.com>
Cc: Langote_Amit_f8@lab.ntt.co.jp, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-bugs@lists.postgresql.org
Date: 2018-10-29T02:44:59Z
Lists: 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
Commits
-
Block creation of partitions with open references to its parent
- 8aad248f7c67 10.6 landed
- 7c222d5e56cc 11.1 landed
- dc3e436b191a 12.0 landed