Hacker News new | ask | show | jobs
by odammit 2955 days ago
FKs and unique indexes are a solid win. Very excited for this!
1 comments
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.
link
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