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 1iR3w7-0001l6-ME for pgsql-docs@arkaria.postgresql.org; Sun, 03 Nov 2019 00:40:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iR3w4-0002IU-DG for pgsql-docs@arkaria.postgresql.org; Sun, 03 Nov 2019 00:40:04 +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 1iR3w4-0002H6-6A for pgsql-docs@lists.postgresql.org; Sun, 03 Nov 2019 00:40:04 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iR3vw-0002Ct-Pr for pgsql-docs@postgresql.org; Sun, 03 Nov 2019 00:40:03 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1iR3vu-00042k-2W for pgsql-docs@postgresql.org; Sat, 02 Nov 2019 20:39:54 -0400 Date: Sat, 2 Nov 2019 20:39:54 -0400 From: Bruce Momjian To: PostgreSQL-documentation Subject: Missing restriction with foreign keys referencing partitioned tables Message-ID: <20191103003954.GA13136@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PG 12 added this feature, mentioned in the release notes: Allow foreign keys to reference partitioned tables (Álvaro Herrera) When I wrote the original release notes in commit bdf595adbc, I had a text description of "LIMITATIONS?". Unfortunately, those limitations were not added to the release notes, and I can't even find where the restriction is mentioned. How should this be improved? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +