Re: Inheritance

Ross J. Reedstrom wrote:
> Actually, I think you'll find that once a PostgreSQL DBA gets to
> the point of designing a sufficently complex schema that inheritance
> might be useful, they quickly bump up against the lack of index and
> constraint spanning (most notably, referential integrity), and stop
> right there. This means that there is little community experience with
> the existing implementation, beyond the OO die hards. ;-)

I'd have to agree wholeheartedly with this, because this was exactly my 
experience the one time I wanted to use inherited tables.

FWIW, one thought I've had before related to inheritance (but pretty 
much orthognal to this discussion) is this: if inheritance included 
shared indexes and constraints, we would be not too far from having 
Oracle style table partitioning.

Joe