Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 08B3F476460 for ; Tue, 11 Jun 2002 12:18:25 -0400 (EDT) Received: from pony (office.weilpublishing.com [207.5.188.53]) by postgresql.org (Postfix) with SMTP id 2194847644D for ; Tue, 11 Jun 2002 12:16:58 -0400 (EDT) Received: (qmail 8038 invoked from network); 11 Jun 2002 16:17:02 -0000 Received: from unknown (HELO weilpublishing.com) ([192.168.1.61]) (envelope-sender ) by 192.168.2.2 (qmail-ldap-1.03) with SMTP for ; 11 Jun 2002 16:17:02 -0000 Message-ID: <3D0622F9.1060506@weilpublishing.com> Date: Tue, 11 Jun 2002 12:19:05 -0400 From: Matt User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.9) Gecko/20020412 Debian/0.9.9-6 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: inheritance problems Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200206/136 X-Sequence-Number: 8101 I have a very general table, Orders, from which three other tables are children. Orders has only two columns cid, oid, have primary key(oid, cid). I want all the children to also have this primary key, and I want uniqness of the primary key enforced accross all children. this was the reason I decided to use inheritance, however I can insert the same entry in two children and then look at the duplicates in the Orders :( is it possible, and if so, how is it done; to have unique primary keys accross all the children. Matthew Berardi WeilPublishing