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

Ühel kenal päeval, K, 2006-07-19 kell 00:20, kirjutas Hannu Krosing:
> Ühel kenal päeval, T, 2006-07-18 kell 16:44, kirjutas Andrew Hammond:
> > On 7/18/06, Aaron Bono <postgresql@aranya.com> wrote: 
> >         On 18 Jul 2006 09:07:08 -0700, Andrew Hammond
> >         <andrew.george.hammond@gmail.com> wrote:
> >         
> >                 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,
> >                     ...
> >                 ); 
> 
> Maybe you can approach the problem from another end, and make the
> many_tables table the virtual one and all the others into real tables ?

Oops, I see you kind of are :)

Maybe you can solve some of the problems doing a VIEW over pl/SQL
function ?

And/or maybe using triggers instead of rules.

-- 
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me:  callto:hkrosing
Get Skype for free:  http://www.skype.com