From: mark overmeer <markovermeer@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: schema design question
Date: Sun, 19 Aug 2007 17:23:14 +0200
Message-ID: <ea41f7570708190823m5b63fc85jfe57c2d3b5d4d842@mail.gmail.com> (raw)
In-Reply-To: <1187533454.4416.0.camel@aleph.wmmi.net>
References: <ea41f7570708190619u6daf7cep96430d20566d6159@mail.gmail.com>
<1187533454.4416.0.camel@aleph.wmmi.net>
Hi Adam,
Thanks for the fast reply. What should inherit from what? Class A (e.g.
'todo item') is certainly not derived from property X (e.g. 'startdate').
Class A version 2 has different properties (some are removed, others are
added). Can you elaborate / say I'm wrong / give an example ? Thanks,
Mark
2007/8/19, Adam Tauno Williams <adamtaunowilliams@gmail.com>:
>
>
> > Maybe not completely the wright place to ask but... I have this schema
> > design question (db is postgres of course). I have a couple of classes
> > with attributes. The only goal is to search the object that I want to
> > find (which is stored on the harddrive).
> > I have hundreds of classes that are similar but not the same. They all
> > have attributes/properties (type is probably String), e.g. (in pseudo
> > code):
>
> Use table inheritance.
>
> --
> Adam Tauno Williams, Network & Systems Administrator
> Consultant - http://www.whitemiceconsulting.com
> Developer - http://www.opengroupware.org
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
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-performance@postgresql.org
Cc: markovermeer@gmail.com
Subject: Re: schema design question
In-Reply-To: <ea41f7570708190823m5b63fc85jfe57c2d3b5d4d842@mail.gmail.com>
* 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