Hacker News new | ask | show | jobs
by arghwhat 2956 days ago
Wait, so you cannot have a FK reference to the partitioned master table? :(
1 comments
pgaddict 2956 days ago
Unfortunately not in PG11, but not because we don't want it - it simply didn't get ready in time.

https://github.com/postgres/postgres/commit/3de241dba86f3dd0...

The relevant limitation is described by CREATE TABLE docs that say

    Partitioned tables do not support <literal>EXCLUDE</literal> constraints
    however, you can define these constraints on individual partitions.
    Also, while it's possible to define <literal>PRIMARY KEY</literal>
    constraints on partitioned tables, creating foreign keys that
    reference a partitioned table is not yet supported.
(the wording is slightly broken in the commit, but got fixed later).
link