Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id E765C9FB4E9 for ; Mon, 22 Jan 2007 05:42:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 95642-05 for ; Mon, 22 Jan 2007 05:41:59 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail01.enterprisedb.com (mail01.enterprisedb.com [63.246.7.168]) by postgresql.org (Postfix) with ESMTP id CAF479FB4E8 for ; Mon, 22 Jan 2007 05:41:59 -0400 (AST) thread-index: Acc+CZSNuzQl4+rNSm2ERYrviH7ItQ== Received: from [192.168.0.22] ([84.12.155.249]) by mail01.enterprisedb.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 22 Jan 2007 04:42:06 -0500 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 Content-Class: urn:content-classes:message Importance: normal Subject: Re: Table Inheritence and Partioning From: "Simon Riggs" To: Cc: In-Reply-To: <47230CE166B64744B0120173E4C2161EED8457@BLR-EC-MBX01.wipro.com> References: <47230CE166B64744B0120173E4C2161EED8457@BLR-EC-MBX01.wipro.com> Content-Type: text/plain; charset="iso-8859-1" Date: Mon, 22 Jan 2007 09:40:22 +0000 Message-ID: <1169458822.3776.245.camel@silverbirch.site> MIME-Version: 1.0 X-Mailer: Evolution 2.6.0 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 22 Jan 2007 09:42:07.0046 (UTC) FILETIME=[94810660:01C73E09] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/338 X-Sequence-Number: 22939 On Wed, 2007-01-17, ramachandra.bhaskaram@wipro.com wrote > We are having 3 tables; > 1. persons <-- Base table and no data will be inserted in this table. > 2. Person1 <-- Inherited table from persons all data will be inserted > in this table. > 3. PersonalInfo <-- which is storing all personal information of the > persons and is having the foreign key relationship with the persons > table. > > When we try to insert the data in the personalInfo table it is > throwing the error stating the primary key does not contain the given > value. But, if I try to select from the persons table it is showing > the records from its inherited tables as well. Can anybody tell me > what might be the problem here? http://www.postgresql.org/docs/8.2/static/ddl-inherit.html answers your questions, I believe. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com