Re: [HACKERS] [SQL] using constraint based paritioning to fix EAV type schemas? (view inheritance and constraints)

2006-07-19 Thread Zeugswetter Andreas DCP SD
> > I've seen a few EAV designs in practice. They've all been problematic. > > I'd like to have a better way of dealing with them. Which is why I'm > > tentatively suggesting support for inheritance and constraints in > > views. If there's some other way to achieve constraint based exclusion >

Re: [HACKERS] [SQL] using constraint based paritioning to fix EAV type schemas? (view inheritance and constraints)

2006-07-19 Thread Zeugswetter Andreas DCP SD
> I've seen a few EAV designs in practice. They've all been > problematic. I'd like to have a better way of dealing with > them. Which is why I'm tentatively suggesting support for > inheritance and constraints in views. If there's some other > way to achieve constraint based exclusion across

Re: [HACKERS] [SQL] using constraint based paritioning to fix EAV type schemas? (view inheritance and constraints)

2006-07-18 Thread Andrew Hammond
On 7/18/06, Aaron Bono <[EMAIL PROTECTED]> wrote: On 18 Jul 2006 09:07:08 -0700, Andrew Hammond < [EMAIL PROTECTED]> wrote: I have a client with the following EAV inspired schema.CREATE TABLE many_tables (table_id text primary key,-- defines which virtual table isencodedattribute1