Hacker News new | ask | show | jobs
by pgaddict 2955 days ago
Keep in mind there are limitations - the unique index / constraint has to include the partition keys, and foreign keys are possible in one direction only. This may be improved in the future, of course.
2 comments
odammit 2955 days ago
You've really got me on an emotional rollercoaster here. :D
link
arghwhat 2955 days ago
Wait, so you cannot have a FK reference to the partitioned master table? :(
link
pgaddict 2955 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