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(at)aranya(dot)com> wrote:
> > On 18 Jul 2006 09:07:08 -0700, Andrew Hammond
> > <andrew(dot)george(dot)hammond(at)gmail(dot)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