Re: [HACKERS] using constraint based paritioning to fix EAV

2006-07-18 Thread Andrew Hammond
Hannu Krosing wrote: > Ühel kenal päeval, T, 2006-07-18 kell 16:44, kirjutas 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 follo

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

2006-07-18 Thread Andrew Hammond
I have a client with the following EAV inspired schema. CREATE TABLE many_tables ( table_id text primary key,-- defines which virtual table is encoded attribute1 text, attribute2 text, attribute3 text, attribute4 text, ... ); I'd like to use a mix of constraint bas