Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 3468C9F985C
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Sun, 19 Aug 2007 12:23:19 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 69886-07 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Sun, 19 Aug 2007 12:23:15 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from rv-out-0910.google.com (rv-out-0910.google.com
 [209.85.198.187])
	by postgresql.org (Postfix) with ESMTP id 474D69F983F
	for <pgsql-performance@postgresql.org>;
	Sun, 19 Aug 2007 12:23:15 -0300 (ADT)
Received: by rv-out-0910.google.com with SMTP id l15so782330rvb
	for <pgsql-performance@postgresql.org>;
	Sun, 19 Aug 2007 08:23:14 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
	b=rIF5Hoxo9zulhOUY6ZQuVxz8yQRjFPV5VpsDnFF/LQFsKypC9xhL9OGfs1ShbAtq1du9REmCHFQGM8YPl64F9G7fPFgVjr02oFXOKUmI9S5eXbNzDHaKg75KbofO7z/atBCEsPQa8R4Y21SKskSwlQCHuLTkicg3idaB5CAaggM=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
	b=r5I6Y9YorKdYEBGy5icX5emuAvS6bweDjNYTbJUAYdlCvEO1oWrBnrhAJOSq9idEEs+qpHvsPASUBuQUF/r8fSuIyG1tGI2V53rwkTRZ0rVJXn7hdevPn48zwMh19J4E6lWqjsmYKWqOPqW8bA8garFn5iAEP+EJstL4fTr6oD0=
Received: by 10.141.21.19 with SMTP id y19mr2161252rvi.1187536994078;
	Sun, 19 Aug 2007 08:23:14 -0700 (PDT)
Received: by 10.141.18.12 with HTTP; Sun, 19 Aug 2007 08:23:14 -0700 (PDT)
Message-ID: <ea41f7570708190823m5b63fc85jfe57c2d3b5d4d842@mail.gmail.com>
Date: Sun, 19 Aug 2007 17:23:14 +0200
From: "mark overmeer" <markovermeer@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: schema design question
In-Reply-To: <1187533454.4416.0.camel@aleph.wmmi.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_41188_22014333.1187536994066"
References: <ea41f7570708190619u6daf7cep96430d20566d6159@mail.gmail.com>
	<1187533454.4416.0.camel@aleph.wmmi.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200708/195
X-Sequence-Number: 26325

------=_Part_41188_22014333.1187536994066
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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
>

------=_Part_41188_22014333.1187536994066
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Adam,<br>
<br>Thanks for the fast reply. What should inherit from what? Class A (e.g. &#39;todo item&#39;) is certainly
not derived from property X (e.g. &#39;startdate&#39;). Class A version 2 has different properties (some are removed, others are added). Can you elaborate / say
I&#39;m wrong / give an example ? Thanks,<br>
<br>Mark<br>
<br><br><div><span class="gmail_quote">2007/8/19, Adam Tauno Williams &lt;<a href="mailto:adamtaunowilliams@gmail.com">adamtaunowilliams@gmail.com</a>&gt;:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>&gt; Maybe not completely the wright place to ask but... I have this schema<br>&gt; design question (db is postgres of course). I have a couple of classes<br>&gt; with attributes. The only goal is to search the object that I want to
<br>&gt; find (which is stored on the harddrive).<br>&gt; I have hundreds of classes that are similar but not the same. They all<br>&gt; have attributes/properties (type is probably String), e.g. (in pseudo<br>&gt; code):
<br><br>Use table inheritance.<br><br>--<br>Adam Tauno Williams, Network &amp; Systems Administrator<br>Consultant - <a href="http://www.whitemiceconsulting.com">http://www.whitemiceconsulting.com</a><br>Developer - <a href="http://www.opengroupware.org">
http://www.opengroupware.org</a><br><br><br>---------------------------(end of broadcast)---------------------------<br>TIP 5: don&#39;t forget to increase your free space map settings<br></blockquote></div><br>

------=_Part_41188_22014333.1187536994066--