Re: partitioned tables referenced by FKs

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread View on postgr.es

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

To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>

Cc: Pg Hackers <pgsql-hackers@postgresql.org>

Date: 2019-03-26T23:27:33Z

Lists: pgsql-hackers

Attachments

v9-0001-Rework-deleteObjectsInList-to-allow-objtype-speci.patch (text/x-diff)

On 2019-Mar-26, Alvaro Herrera wrote:

> Thanks for the thorough testing and bug analysis!  It was spot-on.  I've
> applied your two proposed fixes, as well as added a new test setup that
> covers both these bugs.  The attached set is rebased on 7c366ac969ce.

Attached is rebased on 126d63122232.  No further changes.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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