Received: from darius.concentric.net (darius.concentric.net [207.155.198.79]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA63764; Mon, 11 Oct 1999 15:24:50 -0400 (EDT) (envelope-from dutt@eudoramail.com) Received: from newman.concentric.net (newman.concentric.net [207.155.198.71]) by darius.concentric.net (8.9.1a/(98/12/15 5.12)) id PAA06276; Mon, 11 Oct 1999 15:24:44 -0400 (EDT) [1-800-745-2747 The Concentric Network] Errors-To: Received: from dkalapatapu_pc ([205.158.54.162]) by newman.concentric.net (8.9.1a) id PAA21790; Mon, 11 Oct 1999 15:24:43 -0400 (EDT) Message-Id: <3.0.6.32.19991011122638.009aa3e0@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 12:26:38 -0700 To: pgsql-interfaces@postgreSQL.org From: Dutt Kalapatapu Subject: Question on Inheritance and Primary Keys. Cc: pgsql-sql@postgreSQL.org, dutt@pacbell.net Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" I have two Tables: TableA( parameterone int, parametertwo int, PRIMARYKEY(parameterone), UNIQUE(parameterone) ); TableB( parameterthree int )INHERITS(TableA); 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. But when I insert two duplicate keys in TableA then it complains. This means that Inheritance removes the primarykey etc from the inherited table??? I couldn't think why this object oriented behaviour doesn't work here. Can some one explain this behaviour. Thanks Dutt --Dutt Kalapatapu ________________________ |ipVerse Inc., | |1901 Landings Drive | |Mountain View, CA-94043 | |Telefono: 650 919 0647 | |________________________|