Hi pg-hackers,
I'm trying to fix some of limitations in table inheritance. My first use case concerns "referencing" foreign keys in parent table.
The attached patch propagates foreign keys to inherited tables. I'm automatically cloning foreign keys from parent table into children (with right dependencies). It's the native implementation of work-around described in documentation section 5.9.1. (Caveats).
To be honest it's my first pg hack. Thus it might contain (serious) issues (please be lenient with it).
Furthermore it's not yet documented (TODO !!)
As far as I tested it works pretty well; the internal triggers are installed on CREATE TABLE .. INHERIT and even after ALTER TABLE .. INHERIT.
If you have few minutes to challenge this hack and give your advices, be my guest !
Kind regards,
--
Raphael Medaer
Product Development Engineer
Escaux
Escaux, Communication as easy as the web Chaussée de Bruxelles 408, 1300 Wavre, Belgium
Direct: +3227887564
Main: +3226860900
www.escaux.com
Dit bericht is onderworpen aan de voorwaarden beschikbaar op onze website.
Ce message est soumis aux conditions disponibles sur notre site web.
This message is subject to the terms and conditions available on our website.