Re: Foreign keys and partitioned tables
Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>,
Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2018-03-31T13:09:01Z
Lists: pgsql-hackers
On 3/29/18 23:19, Alvaro Herrera wrote: > 0001 prohibits having foreign keys pointing to partitioned tables, as > discussed above. This is already prohibited. You get an error ERROR: cannot reference partitioned table "fk_partitioned_pk" Your patch 0001 just adds the same error check a few lines above the existing one, while 0003 removes the existing one. I think you can squash 0001 and 0003 together. > 0002 is a fixup for a bug in the row triggers patch: I had a restriction > earlier that triggers declared internal were not cloned, and I seem to > have lost it in rebase. Reinstate it. Hmm, doesn't cause any test changes? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Commits
-
Restore erroneously removed ONLY from PK check
- 7d7c99790b2a 11.0 landed
-
Foreign keys on partitioned tables
- 3de241dba86f 11.0 landed
-
Don't clone internal triggers to partitions
- 851f4b4e1430 11.0 landed
-
Pass correct TupDesc to ri_NullCheck() in Assert
- cd5005bc12d0 11.0 landed