Re: [SQL] referencial conlumn contraints and inheritance

2001-10-17 Thread Stuart
Stephan Szabo and Josh Berkus, Thanks for your input. The question at hand seemed to provide an appealing argument for providing inheritance support for referencial constraints, but if its support is as rare as it seems to be then that could produce problems if I want the ability to b

Re: [SQL] referencial conlumn contraints and inheritance

2001-10-14 Thread Stephan Szabo
On Sun, 14 Oct 2001, Stuart wrote: > Then a destination table set up with a field referencing areas. > Currently postgres appears not to support reference contraints checking > through inherited tables.  Nor does it appear to support subselects in check > constraints.  It would be nice to allow

Re: [SQL] referencial conlumn contraints and inheritance

2001-10-14 Thread Josh Berkus
Stuart, >   I am not sure where to post this.  This may be more of a wishlist > item > than a usage question.  I am new to postgresql 7.1.  Table > inheritance > in postgres seems wonderfull.  Is there the capability now or any > plans to extend support for inherited tables in column constraints

[SQL] referencial conlumn contraints and inheritance

2001-10-14 Thread Stuart
Folks,   I am not sure where to post this.  This may be more of a wishlist item than a usage question.  I am new to postgresql 7.1.  Table inheritance in postgres seems wonderfull.  Is there the capability now or any plans to extend support for inherited tables in column constraints. One exampl