Alvaro Herrera wrote: > After wasting some time trying to resolve > "minor last minute issues", I decided to reduce the scope for now: in > the current patch, it's allowed to have foreign keys in partitioned > tables, but it is not possible to have foreign keys that point to > partitioned tables. I have split out some preliminary changes that > intended to support FKs referencing partitioned tables; I intend to > propose that for early v12, to avoid spending any more time this > commitfest on that.
Hello, I won't be able to work on foreign keys pointing to partitioned tables for the next commitfest, so if somebody is interested in seeing it supported, I applaud they working on it and I offer a bit of time to discuss it, if they're so inclined: CREATE TABLE pktab (a int PRIMARY KEY) PARTITION BY RANGE (a); ... create some partitions ... CREATE TABLE fktab (a int REFERENCES pktab); Thanks, -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
