search

maxtepkeev / architect

A set of tools which enhances ORMs written in Python with more features
Other
391 stars 57 forks source link

Support for Table partitions with FKs #25

Open LordNoteworthy opened 8 years ago

LordNoteworthy commented 8 years ago

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.

maxtepkeev commented 8 years ago

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.

openrijal commented 8 years ago

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

maxtepkeev commented 8 years ago

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