Support for Table partitions with FKs

Open ayoubfaouzi opened this issue 10 years ago • 3 comments

Hello,

I think many of us run into the situation when the primary key of the table which is partitioned is referenced somehow in another table and it would be great if architect could detect this and creates shadow table which will keep track of FKs as show here:

https://postgresinfo.wordpress.com/2012/05/29/table-partition-with-foreign-keys/

Thank you so much.

Dec 16 '15 07:12 ayoubfaouzi

Hi,

Thanks for the feature request.

Yes, implementing this would be really great. I'm aware of this approach with shadow tables and I'm thinking about this feature for a long time, unfortunately due to the lack of my free time I can't tell you the ETA for this and as always pull requests are welcome.

Dec 16 '15 10:12 maxtepkeev

does this apply to https://github.com/maxtepkeev/architect/issues/27

Mar 25 '16 07:03 openrijal

@crackjack Yes, see #27 for a more detailed answer.

Mar 25 '16 08:03 maxtepkeev