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>, Pg Hackers <pgsql-hackers@postgresql.org>

Date: 2019-01-07T18:07:18Z

Lists: pgsql-hackers

Hi,

On 11/30/18 2:12 PM, Alvaro Herrera wrote:
> Here's a more credible version of this patch series.
> 

The patch series applies with hunks, and passes check-world.

No comments for 0001, 0002, 0003 and 0005.

While I'm still looking at 0004 - should we have a test that updates one 
of the constraints of fk to another partition in pk ?

I'll didn't try this yet with [1], so sending you a flamegraph of 
INSERTs off-list, since data loading takes a while during an OLTP based 
work load.

Thanks for working on this !

[1] https://commitfest.postgresql.org/21/1897/

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