Re: Foreign key against a partitioned table - Mailing list pgsql-general

From Adam Brusselback
Subject Re: Foreign key against a partitioned table
Date
Msg-id CAMjNa7dpytkNoAdPBzsegCWgzm-JfTPjTE=3q3Bx_aDRmKr-Cg@mail.gmail.com
Whole thread Raw
In response to Re: Foreign key against a partitioned table  (Igor Neyman <ineyman@perceptron.com>)
List pgsql-general
I have wondered if there were any plans to enhance fkey support for partitioned tables now that more work is being done on partitioning (I know there has been a large thread on declarative partitioning on hackers, though I haven't followed it too closely).

Foreign keys are all done through triggers on the backend anyways, it does seem totally possible to have it work for partitioned tables if the code is aware that a table is partitioned and it needs to look in all inherited tables as well as the one specified.

pgsql-general by date:

Previous
From: Terry Schmitt
Date:
Subject: Re: PG vs ElasticSearch for Logs
Next
From: Adrian Klaver
Date:
Subject: Re: Foreign key against a partitioned table