Subject: Re: BUG #15437: Segfault during insert into declarative partitioned
 table with a trigger creating partition
References: <15437-3fe01ee66bd1bae1@postgresql.org>
 <e8079b1f-3e41-d1dc-1575-ff3cce7d76ac@lab.ntt.co.jp>
 <8213.1539917571@sss.pgh.pa.us>
 <ddc70376-9ddb-8637-eb69-aa7ae6f13378@lab.ntt.co.jp>
 <CAKPeCUGE2VJD3Z7j7gTAZuEWW=z0hff-WNcwNNt=2KFt8ma+aw@mail.gmail.com>
 <20181029024459.GD14242@paquier.xyz>
From: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Message-ID: <5d9c4f7a-52aa-a8bb-9a52-e93118f56a40@lab.ntt.co.jp>
Date: Mon, 29 Oct 2018 14:15:06 +0900
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101
 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: <20181029024459.GD14242@paquier.xyz>
Content-Type: text/plain; charset=windows-1252
Content-Language: en-US
Content-Transfer-Encoding: 7bit
To: Michael Paquier <michael@paquier.xyz>,
        Dmitry Shalashov <skaurus@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-bugs@lists.postgresql.org
Precedence: bulk

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