Re: partitioned tables referenced by FKs

Jesper Pedersen <jesper.pedersen@redhat.com>

From: Jesper Pedersen <jesper.pedersen@redhat.com>

To: Alvaro Herrera <alvherre@2ndquadrant.com>

Cc: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, Pg Hackers <pgsql-hackers@postgresql.org>

Date: 2019-03-01T14:55:46Z

Lists: pgsql-hackers

Hi Alvaro,

On 2/28/19 1:28 PM, Alvaro Herrera wrote:
> Rebased to current master.  I'll reply later to handle the other issues
> you point out.
> 

Applying with hunks.

With 0003 using

export CFLAGS="-DCOPY_PARSE_PLAN_TREES -O0 -fno-omit-frame-pointer" && 
CC="ccache gcc" ./configure --prefix /usr/local/packages/postgresql-12.x 
--enable-dtrace --with-openssl --with-gssapi --with-libxml --with-llvm 
--enable-debug --enable-depend --enable-tap-tests --enable-cassert

I'm getting a failure in the pg_upgrade test:

  --
+-- Name: pk5 pk5_pkey; Type: CONSTRAINT; Schema: regress_fk; Owner: 
jpedersen
+--
+
+ALTER TABLE ONLY regress_fk.pk5
+    ADD CONSTRAINT pk5_pkey PRIMARY KEY (a);
+
+
+--

when running check-world.

Best regards,
  Jesper

Commits

Support foreign keys that reference partitioned tables
- f56f8f8da6af 12.0 landed
Fix partitioned index creation bug with dropped columns
- 7009f1a2df65 11.3 landed
- 126d63122232 12.0 landed
Improve psql's \d display of foreign key constraints
- 1af25ca0c2d9 12.0 cited
Fix dependency recording bug for partitioned PKs
- 7e7c57bbb2eb 12.0 landed
Add index_get_partition convenience function
- a6da0047158b 12.0 landed
Restore RI trigger sanity check
- 815b20ae0c6e 12.0 landed
- 04f9b449aa30 11.3 landed
Foreign keys on partitioned tables
- 3de241dba86f 11.0 cited