Re: [GENERAL] foreign key constraints with inhertiance, hack suggestions?

2007-03-22 Thread Alban Hertroys
George Nychis wrote: Basically I have a master 'flows' table which is partitioned and has non-overlapping CHECK constraints on each partition. Each record in the partitions have a unique pair of attributes: interval, flow_id When inserting in to another table 'flow_labels', these two

[GENERAL] foreign key constraints with inhertiance, hack suggestions?

2007-03-21 Thread George Nychis
Hi, First, yes I have read the 5.8.1. Caveats section that this support does not exist. I agree with the document that this is a serious limitation of the inheritance feature Has there been any effort to support this in the near future versions of postgresql? I searched the mailing lists