Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fTHWW-0006oN-2T for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Jun 2018 01:58:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fTHWU-0002oa-QT for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Jun 2018 01:58:02 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fTHWU-0002oR-H3 for pgsql-bugs@lists.postgresql.org; Thu, 14 Jun 2018 01:58:02 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fTHWQ-0002Mr-Pb for pgsql-bugs@lists.postgresql.org; Thu, 14 Jun 2018 01:58:01 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 22A9D21CD0; Wed, 13 Jun 2018 21:57:58 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Wed, 13 Jun 2018 21:57:58 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to:x-me-sender:x-me-sender:x-sasl-enc; s= fm1; bh=OTZ900iAg0s2z7cNEeJay9vR7HGd93RqOre0iL2R2kA=; b=KpJJWaS+ aC3p6YNrkj74ibV7QDuykqSDa+MvL0oUQ+DNGIrzWIX5PlJeJCRRcI0L4SpgNpHi rr1rTOB16WaUWMxB74KOKKgfaPA0YZ4I+6qPPvzci1IpfeHCqIlCIN7cd8coVt9t T4Jsq1CoHh8J0csiAKTFIpS9ukhz4gtHRw53CA9K2QGRPSbHBLTzHOpbkvkOdJ5X QLSEzTDScb6WL3Qil+jD8VMgKqUNwHUwKev+XdVDuPe7xhWkhlXEFsFVY4SWCFTs +hWDDr7FZXUPRqIzW2yjusyIr5pMYNk6wYk+f3gw9Od2VlbqVSxDlnXHGJViUiLA UdiZB52paMKVDQ== 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-sender :x-me-sender:x-sasl-enc; s=fm3; bh=OTZ900iAg0s2z7cNEeJay9vR7HGd9 3RqOre0iL2R2kA=; b=Tm9oLQ4Vo5xcv6agSPmFQDr3pRO7cVF75x4aQbjkEwbsa ydOYWblZ47dl0bh3hTRUOIPUxj0UrJIR+io1+3I5Nw/m91h7OqciRZPzyEOVVilw ZpgZofKmLORyeCiufz5XYvVCh3AfaeV8MYdCar4hQOh82dMbrn4QUh6W9cDaJEmf /ao13c/Zv8N/mOsl9SEz3OhOVUKmbo3iYff4mAYMVTy6y2M03EIRUSJ1A4C7CHnl PV9jiad/O6Wcgp4aukmLY245hDZnc5fuDUOnLBhKgtUEkd76WgrvDosGKGZ1kFW8 ifIJRbkuozn67umZLN6PniIuWe+D0Spp597lGaWfA== X-ME-Proxy: X-ME-Proxy: X-ME-Proxy: X-ME-Proxy: X-ME-Proxy: X-ME-Proxy: X-ME-Sender: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 34B2AE465D; Wed, 13 Jun 2018 21:57:56 -0400 (EDT) Date: Thu, 14 Jun 2018 10:57:53 +0900 From: Michael Paquier To: =?iso-8859-1?Q?J=FCrgen?= Strobel Cc: Amit Langote , Dmitry Dolgov <9erthalion6@gmail.com>, pgsql-bugs@lists.postgresql.org, PG Bug reporting form Subject: Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Message-ID: <20180614015753.GD1597@paquier.xyz> References: <152746742177.1291.9847032632907407358@wrigleys.postgresql.org> <23628f29-6cb7-7cea-4329-84774374e335@lab.ntt.co.jp> <2fd8e258-af80-aab8-8028-30fb1320443a@strobel.info> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="lkTb+7nhmha7W+c3" Content-Disposition: inline In-Reply-To: <2fd8e258-af80-aab8-8028-30fb1320443a@strobel.info> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --lkTb+7nhmha7W+c3 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jun 13, 2018 at 03:39:04PM +0200, J=FCrgen Strobel wrote: > I agree, and I imagine especially being able to use per-partition > sequences would be a common use case. That was my motivation when I > discovered it, and it was very counter intuitive to me. >=20 > Thanks for the NULL violation patch btw. Please note that I have added this thread to the Open item page, under the older bug queue, and that a CF entry has been added so as we don't lost track of it: https://commitfest.postgresql.org/18/1671/ -- Michael --lkTb+7nhmha7W+c3 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlshy6EACgkQnvQgOdby QH3Q2A/9FQzFjW/WgaJJHCvW0NkBuQBHIi6h8RXIVSmD3E2arZ/aF4jJ153vaKS4 AmAqvLpjKvMqwUjXB57IYJvQ0ikz4skj6oZBGSWxH4OK475tEvRPGzi+lZNN7oeA 7XLw2w/8Zw9WHLNhDN1+yk0EY7eJ1iSOFi4+4hDAi7IAgv9QlWbQpzHxG/4uPCrf BFOsFup6sc1MPERwrrNXR5Q++7T0Ft6L/6fh3eBsh9oJXNy3k4eLtR0nrzyFkde0 EoZLjgLV266hBTRPuoaJV9JLTTpOIj1aJsRyX8jUWYeAbz0G/2oGAcg9ZLP/Jgmz pEjtiOc9pXNQyp8wZ0uobBIoGc1dErILj3rg0/HUkVzSpYLtCq3U6Q+Z1XggYTGz GIndPCCZbQj2a+cBTzhvkXx8kCL2NbVRurljvY2vBJ8kze3zly4LjExcOlmxgvbD vJ1FVrR7nB6wGd66MEeN+0umnoCSZAnjqMU+njTxRIUefzpocR6e/2thnF9ufu9G dQU9jBB1FCCxFHDBEtmaezJaVge38FovWoNGxkABwqltbA0zIqU4LI82XlZ0hgAK oHSP4d/qCzwxxEQ2yhRJ/ME9kH9+p5t5vzDJfCCHOsHMkwUlxCNApPqFbpMHMyTW lrDKBnGPWnWYQq/C36vyiDVtdcJmB5nr595Su9mdD70A0UJnGbw= =Hx13 -----END PGP SIGNATURE----- --lkTb+7nhmha7W+c3--