DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:from:to:subject:date:user-agent:cc:references:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:message-id:x-virus-scanned;
	b=E82Q2y911N+bRwPFDtfWROpiMUMw+KotnxvCfeNu+TK/lqsTt2TxV9Rjt68H9e6kg7brnriorInrzTFcO61wirj6jUhNNzj3AgljKTR7L8x+B5pXGWdgZHFB8nTVOUARIRAdmM5BFOfcW1DvwsM7w8rdJAmO9tRw6YezfWy9eb0=
From: Jorge Godoy <jgodoy@gmail.com>
To: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Re: [SQL] (Ab)Using schemas and inheritance
Date: Wed, 24 May 2006 14:56:43 -0300
User-Agent: KMail/1.9.1
Cc: Alban Hertroys <alban@magproductions.nl>,
	"Jim C. Nasby" <jnasby@pervasive.com>, pgsql-general@postgresql.org
References: <20060524174855.47650.qmail@web31807.mail.mud.yahoo.com>
In-Reply-To: <20060524174855.47650.qmail@web31807.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200605241456.45645.jgodoy@gmail.com>

Em Quarta 24 Maio 2006 14:48, Richard Broersma Jr escreveu:
>
> From what I've read I am not sure that an Index created on the base/parent
> table will help when preforming select queries on data across all of the
> children.  If I interpret the "Caveats" correctly I would assume that the
> index will only apply to data that is inserted directly into the
> base/parent table.

It won't.  What I was saying is that I don't need an index just for this 
reason because data partitioning would be intrinsic to the inheritance 
solution.  I was thinking as described in 
http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html  
(please, see 5.9.2, specially).

With his solution I'd need an index to have this partitioning implemented and 
I'd suffer without it.  With inheritance I just need this index if I'm 
actually operating with dates, not to just retrieve the right data for a 
given year (whatever that means ;-)).

> From the Manual:
>
> 5.8.1. Caveats
>
> ...
>
> A serious limitation of the inheritance feature is that indexes (including
> unique constraints) and foreign key constraints only apply to single
> tables, not to their inheritance children. This is true on both the
> referencing and referenced sides of a foreign key constraint.

This is why, in one of the messages, I've said that I'd have to create indices 
for children tables.  But hey, it is nice that you're also helping us 
here :-)  Thanks! :-)

-- 
Jorge Godoy      <jgodoy@gmail.com>