Received: from uhura.concentric.net (uhura.concentric.net [206.173.118.93]) by hub.org (8.9.3/8.9.3) with ESMTP id VAA35531; Mon, 11 Oct 1999 21:29:16 -0400 (EDT) (envelope-from dutt@eudoramail.com) Received: from marconi.concentric.net (marconi.concentric.net [206.173.118.71]) by uhura.concentric.net (8.9.1a/(98/12/15 5.12)) id VAA00702; Mon, 11 Oct 1999 21:28:56 -0400 (EDT) [1-800-745-2747 The Concentric Network] Errors-To: Received: from dkalapatapu_pc ([205.158.54.162]) by marconi.concentric.net (8.9.1a) id VAA06910; Mon, 11 Oct 1999 21:28:53 -0400 (EDT) Message-Id: <3.0.6.32.19991011183045.00993a10@pop.eudoramail.com> X-Sender: dutt@pop.eudoramail.com X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.6 (32) Date: Mon, 11 Oct 1999 18:30:45 -0700 To: Tom Lane From: Dutt Kalapatapu Subject: Re: [SQL] Question on Inheritance and Primary Keys. Cc: pgsql-interfaces@postgreSQL.org, pgsql-sql@postgreSQL.org, dutt@pacbell.net In-Reply-To: <10277.939691262@sss.pgh.pa.us> References: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" If I redeclare the Values again, will it overwrite the inherited values? Thanks for the clarification. -Dutt At 09:21 PM 10/11/99 -0400, Tom Lane wrote: >Dutt Kalapatapu writes: >> I expect from this that when we insert some thing in TableB then >> parameterone should be unique, but the database is not enforcing the rule >> and it takes duplicate values. > >Constraints and indexes aren't inherited; you have to redeclare them for >each derived table. I agree this is a bug, or at least lack of a >feature that ought to be there. It's on the TODO list, in fact: > >* Unique index on base column not honored on inserts from inherited table > INSERT INTO inherit_table (unique_index_col) VALUES (dup) should fail > [inherit] > >I don't know when it might get fixed. None of the currently active >developers seem to be very interested in inheritance issues, so it >could be a while before anyone decides to look at this problem. > > regards, tom lane > --Dutt Kalapatapu ________________________ |ipVerse Inc., | |1901 Landings Drive | |Mountain View, CA-94043 | |Telefono: 650 919 0647 | |________________________|