Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gGxYV-0007Tv-R0 for pgsql-bugs@arkaria.postgresql.org; Mon, 29 Oct 2018 02:45:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gGxYU-0002HM-14 for pgsql-bugs@arkaria.postgresql.org; Mon, 29 Oct 2018 02:45:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gGxYT-0002G4-Nv for pgsql-bugs@lists.postgresql.org; Mon, 29 Oct 2018 02:45:25 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gGxYB-0004Uk-F1 for pgsql-bugs@lists.postgresql.org; Mon, 29 Oct 2018 02:45:24 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id E16D2E39; Sun, 28 Oct 2018 22:45:05 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Sun, 28 Oct 2018 22:45:06 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=MiBdFHC+MIIH4eAalKyEGvhGzM6 hPEWUyEGL3NF/bDI=; b=NFu4zqEF4YiqqmaECupsLmsXJS1+mEKIkZEtOBh6JC1 0alb4mBf1I7kM5sALbSztv1DbK4996RzLdWwYPQhS6L9gu4GfcEY4dGdC5J2YE7C +ldbKufEyVO1nSvCkLPOnpkb6SeFmMuUM4b3eGR+CBPd43sC2hLvXCj9LpjYpka8 exxABj6ejIpnLMkHqpQztYYF8K6FwcrwheiarkqKswVjT8EmhIdZtqN7vtpiVXRv Nu55K05Zm+bA8hyD4AFWVPhFlcHvN2+aRfLu/+ETuXhMFW1nXac8aPcPPLARsm8a 9ORJ26B0D1AUW2/JeZ4FXXUDnKsJ7aJ7uRthNXSABWg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=MiBdFH C+MIIH4eAalKyEGvhGzM6hPEWUyEGL3NF/bDI=; b=pc27cDBY3NSKPMiI7I8RXq Fyzu25Tcqh4rYXiOBUhTLC5uZ0o/VGts3gqEKVLcRW2NwHDoMxKl/jf16iDmr2Y+ G5mkzU1/qkbHRI+UERg3QpndwOm2sl1Iy3GQMX/9+SmkrXK9oKxHQmvnUL6VzBu7 fxv+1ED+DG2Mpvyngwr2PsJUjQWRVMVI83QSU1oDEXbTblNoP8mRWQkyACa8oxNu 2mKdnvN1OiqIxzOstgz4nUDUkJCVCNn8t6MoN1ch3uVd7H/1E1enbQPfaOofAeQ+ 7R4ek4kCG4CESNJGA1nv11fmcuoDLZW6zLH26jQBY+DlhfX2n9Mw7lXSKIUhbIgA == X-ME-Sender: X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 6B08D102EA; Sun, 28 Oct 2018 22:45:02 -0400 (EDT) Date: Mon, 29 Oct 2018 11:44:59 +0900 From: Michael Paquier To: Dmitry Shalashov Cc: Langote_Amit_f8@lab.ntt.co.jp, Tom Lane , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #15437: Segfault during insert into declarative partitioned table with a trigger creating partition Message-ID: <20181029024459.GD14242@paquier.xyz> References: <15437-3fe01ee66bd1bae1@postgresql.org> <8213.1539917571@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="vni90+aGYgRvsTuO" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --vni90+aGYgRvsTuO Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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 --vni90+aGYgRvsTuO Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlvWdCsACgkQnvQgOdby QH2i1Q/9HG4AC1TUh5jlVwRVybZU9MwJgpKYPpNXQ6CrBHQ0b8Wp94Mdp3aefrCs TdtgGHLa6Ftx1JGmXw0IepLX6D8cx2yfmlEHYWzLgIy2A0k0ossktLuUY4DMI9Wx 69aXFlswKwXMOrGcN5ASjD5Kxf8VW+IdfUV6mG3hxm1UlUwjBL3lHJX/Kpm87iUl US/IchGmaZtrXqiyZZZZjwaSicg0fezfI8yii/Xd9608d0l4r0JdROlxJOJkPG9F dCl/LEDdMSPl1NYf88lsFHecLq8oPVPW1o9Q0ZP5QCrrNUmBDiMtquHD99jqvFz3 U9yBTj2uUKOwz8j4B5Dixr8CYXh+qBCbWRNcAB1FvflKnUzKihV10caycAo9XBbf N4ECnmuIuaE7ANUuhKMU/VKUaPLVuwRuNL36bhx6i76Bzm+pQmt7LD2nboqO94Oo kKdq1Z4Z3FnRfzY7ST6V0muBlGaEKZVi8G1N4+nBF9+HAPvOLbxwegam2SKWitwp 024Doz079a6DrcoIuoHQ7qqX5L6rkD0eIPjYAER1oT8KFfnLSYQ08vXcaRkOKuCu VoR636utWIphEZn0Nb9/IZu6bCU302FzECLjo5UhsEsN7m1VLok9UozaAJU4cOKQ pgChA+BSyBVmDP5NXB9AbC4CMklSLUYaZ82YqsBPLghplNWEWjg= =LSFP -----END PGP SIGNATURE----- --vni90+aGYgRvsTuO--