Re: Attempt to fix inheritance limitations: unique and foreign key constraints

2018-06-15 Thread Raphael Medaer
Hi Robert, Sounds very similar to commit 3de241dba86f3dd000434f70aebba725fb928032. I'm reusing part of the code from this commit (mainly "CloneForeignKeyConstraints").. But this commit concerns only partitioned tables.. not inherited tables. Kind regards, -- Raphael Medaer Product Developm

Re: Attempt to fix inheritance limitations: unique and foreign key constraints

2018-06-14 Thread Robert Haas
On Tue, Jun 12, 2018 at 11:28 AM, Raphael Medaer wrote: > 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

Attempt to fix inheritance limitations: unique and foreign key constraints

2018-06-12 Thread Raphael Medaer
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