pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Hannu Krosing <hannu@skype.net>
To: Andrew Hammond <andrew.george.hammond@gmail.com>
Cc: Aaron Bono <postgresql@aranya.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: [SQL] using constraint based paritioning to fix EAV
Date: Wed, 19 Jul 2006 00:20:22 +0300
Message-ID: <1153257622.3681.1.camel@localhost.localdomain> (raw)
In-Reply-To: <5a0a9d6f0607181344g530b4d09s393f3f0b46764fbe@mail.gmail.com>
References: <1153238828.426611.113540@35g2000cwc.googlegroups.com>
	<bf05e51c0607181131s488e93bane69a37001ab0912@mail.gmail.com>
	<5a0a9d6f0607181344g530b4d09s393f3f0b46764fbe@mail.gmail.com>

Ü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 ?

-- 
----------------
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

view thread (6+ messages)  latest in thread

Message-ID: <1153257622.3681.1.camel@localhost.localdomain>
Permalink:  ../1153257622.3681.1.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1153257622.3681.1.camel@localhost.localdomain

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: hannu@skype.net, andrew.george.hammond@gmail.com, postgresql@aranya.com, pgsql-hackers@postgresql.org
  Subject: Re: [SQL] using constraint based paritioning to fix EAV
  In-Reply-To: <1153257622.3681.1.camel@localhost.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox