Re: [GENERAL] table references with partitioning

2008-03-19 Thread Erik Jones
On Mar 19, 2008, at 12:54 PM, dan chak wrote: I'm running into a problem with maintaining referential integrity with inheritance-based partitioning. Imagine a situation where partitions are based on time. Two tables A and B are partitioned, and B references A. If records in B are added

[GENERAL] table references with partitioning

2008-03-19 Thread dan chak
I'm running into a problem with maintaining referential integrity with inheritance-based partitioning. Imagine a situation where partitions are based on time. Two tables A and B are partitioned, and B references A. If records in B are added some time after records in A, the insertion tim