From: Simon Riggs <simon@2ndquadrant.com>
To: ramachandra.bhaskaram@wipro.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Table Inheritence and Partioning
Date: Mon, 22 Jan 2007 09:40:22 +0000
Message-ID: <1169458822.3776.245.camel@silverbirch.site> (raw)
In-Reply-To: <47230CE166B64744B0120173E4C2161EED8457@BLR-EC-MBX01.wipro.com>
References: <47230CE166B64744B0120173E4C2161EED8457@BLR-EC-MBX01.wipro.com>
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
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: simon@2ndquadrant.com, ramachandra.bhaskaram@wipro.com
Subject: Re: Table Inheritence and Partioning
In-Reply-To: <1169458822.3776.245.camel@silverbirch.site>
* 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