{"action":"created","issue":{"url":"https://api.github.com/repos/keithf4/pg_partman/issues/53","labels_url":"https://api.github.com/repos/keithf4/pg_partman/issues/53/labels{/name}","comments_url":"https://api.github.com/repos/keithf4/pg_partman/issues/53/comments","events_url":"https://api.github.com/repos/keithf4/pg_partman/issues/53/events","html_url":"https://github.com/keithf4/pg_partman/issues/53","id":63105722,"number":53,"title":"Question: Partition to partition fk's","user":{"login":"hopesea","id":6063467,"avatar_url":"https://avatars.githubusercontent.com/u/6063467?v=3","gravatar_id":"","url":"https://api.github.com/users/hopesea","html_url":"https://github.com/hopesea","followers_url":"https://api.github.com/users/hopesea/followers","following_url":"https://api.github.com/users/hopesea/following{/other_user}","gists_url":"https://api.github.com/users/hopesea/gists{/gist_id}","starred_url":"https://api.github.com/users/hopesea/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hopesea/subscriptions","organizations_url":"https://api.github.com/users/hopesea/orgs","repos_url":"https://api.github.com/users/hopesea/repos","events_url":"https://api.github.com/users/hopesea/events{/privacy}","received_events_url":"https://api.github.com/users/hopesea/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-03-19T22:23:57Z","updated_at":"2015-03-19T22:36:47Z","closed_at":null,"body":"Is there any support for pg_partman to create foreign keys between the partitions of two tables; ie. where the parent tables have a foreign key constraint between them, and have pg_partman establish the foreign keys between each of the corresponding partitions beneath those two tables?\r\n\r\nThe behaviour I observe is that the foreign key is established between the partition and the parent related table rather than the partition of the related table."},"comment":{"url":"https://api.github.com/repos/keithf4/pg_partman/issues/comments/83788119","html_url":"https://github.com/keithf4/pg_partman/issues/53#issuecomment-83788119","issue_url":"https://api.github.com/repos/keithf4/pg_partman/issues/53","id":83788119,"user":{"login":"keithf4","id":825402,"avatar_url":"https://avatars.githubusercontent.com/u/825402?v=3","gravatar_id":"","url":"https://api.github.com/users/keithf4","html_url":"https://github.com/keithf4","followers_url":"https://api.github.com/users/keithf4/followers","following_url":"https://api.github.com/users/keithf4/following{/other_user}","gists_url":"https://api.github.com/users/keithf4/gists{/gist_id}","starred_url":"https://api.github.com/users/keithf4/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/keithf4/subscriptions","organizations_url":"https://api.github.com/users/keithf4/orgs","repos_url":"https://api.github.com/users/keithf4/repos","events_url":"https://api.github.com/users/keithf4/events{/privacy}","received_events_url":"https://api.github.com/users/keithf4/received_events","type":"User","site_admin":false},"created_at":"2015-03-19T22:36:47Z","updated_at":"2015-03-19T22:36:47Z","body":"I believe I discuss what your asking in the later part of my blog post for when I released the FK feature I do support. It's very tricky situation with the way partitioning uses table inheritance and I honestly don't have any idea how to support this in a sane manner at this point.\r\n\r\nhttp://www.keithf4.com/table-partitioning-and-foreign-keys/"}}