Re: partitioned tables referenced by FKs

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Alvaro Herrera <alvherre@2ndquadrant.com>, Amit Langote <amitlangote09@gmail.com>, Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, Pg Hackers <pgsql-hackers@postgresql.org>

Date: 2019-04-03T12:51:37Z

Lists: pgsql-hackers

On Tue, Apr 2, 2019 at 11:07 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The problem this patch is running into is that we'd like to make the
> validity of dropping a table partition depend on whether there are
> individual rows in some other table that FK-reference rows in the target
> partition.  That's just completely outside the object-dependency model,
> and I'm not sure why Robert finds that surprising.

I think it's because I was misunderstanding the problem.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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