Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id E825D9F9D99 for ; Thu, 16 Nov 2006 13:39:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 27209-01 for ; Thu, 16 Nov 2006 13:39:15 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail01.enterprisedb.com (mail01.enterprisedb.com [63.246.7.168]) by postgresql.org (Postfix) with ESMTP id 85BDC9F946B for ; Thu, 16 Nov 2006 13:39:12 -0400 (AST) thread-index: AccJpiF3HuzJT99KTv+G3uYhzXpQYA== Received: from [192.168.0.20] ([62.232.55.118]) by mail01.enterprisedb.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 16 Nov 2006 12:39:12 -0500 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 Content-class: urn:content-classes:message Importance: normal Subject: Re: Question on partitioning From: "Simon Riggs" To: "Mark Steben" Cc: In-Reply-To: <001201c708f2$839a8c00$b501a8c0@D1RPQZB1> References: <001201c708f2$839a8c00$b501a8c0@D1RPQZB1> Content-Type: text/plain; charset="utf-8" Date: Thu, 16 Nov 2006 17:38:42 +0000 Message-ID: <1163698723.27956.554.camel@silverbirch.site> MIME-Version: 1.0 X-Mailer: Evolution 2.6.0 Content-Transfer-Encoding: quoted-printable X-OriginalArrivalTime: 16 Nov 2006 17:39:13.0296 (UTC) FILETIME=[2166E100:01C709A6] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/162 X-Sequence-Number: 23689 On Wed, 2006-11-15 at 15:13 -0500, Mark Steben wrote: > Regarding partitioning =E2=80=93 I set up a testing table =E2=80=93 paren= t table and 4 > partitioning children=E2=80=99s tables inheriting the >=20 > Attributes of the parent. I inserted 1800 rows in all =E2=80=93 450 equi= tably > in each partition. The CHECK constraints work great. >=20 > The PART_ID column, defined as SMALLINT, Is the partitioning > column. =20 >=20 You'll probably want to look at the caveats here http://www.postgresql.org/docs/8.2/static/ddl-partitioning.html#DDL-PARTITI= ONING-CAVEATS especially the ones about cross-datatype comparisons in CHECK constraints. --=20 Simon Riggs =20 EnterpriseDB http://www.enterprisedb.com