Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hkjwU-0004kJ-M0 for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Jul 2019 06:49:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hkjwT-0003aE-HV for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Jul 2019 06:49:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hkjwT-0003WO-6T for pgsql-hackers@lists.postgresql.org; Tue, 09 Jul 2019 06:49:33 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hkjwQ-0002xF-V9 for pgsql-hackers@postgresql.org; Tue, 09 Jul 2019 06:49:32 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 8FF15394; Tue, 9 Jul 2019 02:49:28 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Tue, 09 Jul 2019 02:49:28 -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=fm2; bh=5TLlh2V3B8MpoLCgxTWF1Wf/Klh nHxR29C7p4Y52mj4=; b=uXSOk3FyyDJnnbi4NkdHRQlz7Se39TuWBzYNhxytf+O GRTiz++uftnHePx9djLdH7RA9AZ7JYJGg9iOVPjjt8OWjpqCC4sfDIIOa/eCxrZH VGO/McqInBjuX1//UShD/RsL51PPdTdtJ+W4X+IE1TMPXNaympYTDh8fj9ZBuuwh AeULSQxTxkM92Xy/GDh7bG0msyM0QvzNKPKHqRHPj8csY2QJXBdiYVbwCr16L+1C eccmgw1sqvxAntlOWxmfuPML6L0B4sMLahvWBXGD3y1fJDPzdLY1bgAxjG+TC5dA PTm198pRTjWyiRJQq4qUSJzduBw6lJEJA9sgbrop3hg== 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=fm3; bh=5TLlh2 V3B8MpoLCgxTWF1Wf/KlhnHxR29C7p4Y52mj4=; b=mTW8MibQBJkd30Ca3g48CE NNM8vRwDHvgbIFsD5HZvP5oqz23CEYgj/BoSh9TFnCWPwWxdbxRIuO1sVNiqdaZH kmIOmWHpbnxrXW8VZgV7VIq6O1pniSpQ+S5nSjFziog+gQ1qklkvYGp0oo3pEf58 NBJwutwTYEDXHoVKj7T1rKeTMZpofnv/tuh7Zwo7JddwDK+kLZ5gz53yyfh+/A1v CzT5D+BUbAX3T1/L3BFE6Q2N+PBf9y2jrSAR6qwaEQhbFTOtIOnmWT611BgDHv3n BvCd4TGYVw5GJA7fkhq5mFb4sxygxn6ey1g1Ke2CEdcZkJKzpHQAf3U6+tzgD5hw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduvddrgedugdduuddvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucfkphepudduuddruddtvddrudektddrudekheenucfrrghr rghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlh hushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 7597B80060; Tue, 9 Jul 2019 02:49:26 -0400 (EDT) Date: Tue, 9 Jul 2019 15:49:24 +0900 From: Michael Paquier To: Tom Lane Cc: Bruce Momjian , phil.bayer@gmail.com, pgsql-docs@lists.postgresql.org, PostgreSQL-development Subject: Re: Postgres 11: Table Partitioning and Primary Keys Message-ID: <20190709064924.GA17321@paquier.xyz> References: <156236160709.1192.4498528196556144085@wrigleys.postgresql.org> <20190709023737.vhrd4pxe4hgnd3ks@momjian.us> <20190709025856.GC1345@paquier.xyz> <18801.1562641851@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="vkogqOf2sHV7VnPd" Content-Disposition: inline In-Reply-To: <18801.1562641851@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --vkogqOf2sHV7VnPd Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Mon, Jul 08, 2019 at 11:10:51PM -0400, Tom Lane wrote: > Isn't it the other way around, that the partition key column(s) must > be > included in the primary key? Maybe I'm confused, but it seems like > we couldn't enforce PK uniqueness otherwise. Yes you are right. The full column list of the partition key needs to be included in the constraint, but that's not true the other way around. -- Michael --vkogqOf2sHV7VnPd Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl0kOPQACgkQnvQgOdby QH2lDA/+NsrKgGouWCsYyo43jrylNaF99Bk0V6NwQMHyrI3/vAH4ifEOsGrqcxjH E79d+LWkm3G01z3uA8GwSg6wrn0f1V/Wr3bDCgmG0xqcMyndsqku1qcqQiiApF+N fR7wGKf3J6MPKHaSI6rgoD4RT/sl43PGL/2HGTm0GK6IWcJHRAWHIKYWH92X0+nu aa4RaqPDNAJyeknO9+8PQhG7jfXa50AwUvXCqiWsbXLTUReQEjMBZZKD6lC1q3Lk wRkey62EdLNwQJiH+jTQXUoynOI5p/q9XiFEQPX2wy/pqbmpxFtGVUh5mNkQhsiK hnIq1GlN/elM1IJnx2i0zvubLW2vH5pgdJvM7gnZ3fMrPoOWj2hLR/ICtuWtYy6h U758s8xZ88TNeUT7CFtrS5B9uteARX2GGlwoGy8icJiX9+4q5PsafV3WTY9vGzYX g5AStceZ/7PPYq6CSlV4faKYGfdGevlGGcT5OFWQHkB/SW8eanixb+1rGAY/dCTq sVwD8JFAKFv1MfV1A/0tBcXvlVU0WrnwIKy6+JDADMElgIpZejK4f7IlioG/j1v2 Llss4IR1CLHtGI7yLiV3wCpJhefEiZp9OKHO6eGPnxDGhf7kkaC+y/xJaiaY7bEq ZnZZ3W9LlDje/JGQmKMaf5+Lyu4BJ+VKb0BJlDEDDuHUL6s0Kug= =e4D2 -----END PGP SIGNATURE----- --vkogqOf2sHV7VnPd--