Received: from mercury.sterlingdi.com (mercury.sterlingdi.com [204.183.83.11]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA46091 for ; Mon, 20 Dec 1999 10:00:01 -0500 (EST) (envelope-from linderdm@ironhilltech.com) Received: from stargate.sterlingdi.com (stargate.sterlingdi.com [204.183.83.3]) by mercury.sterlingdi.com (8.9.3/8.9.3/SuSE Linux 8.9.3-0.1) with SMTP id KAA03335 for ; Mon, 20 Dec 1999 10:00:53 -0500 Received: from hermes.gg.sterlingdi.com by stargate.sterlingdi.com via smtpd (for mercury.sterlingdi.com [204.183.83.11]) with SMTP; 20 Dec 1999 14:27:45 UT Received: from brewmaster.eng.ironhilltech.com (IDENT:root@brewmaster.eng.sterlingdi.com [207.169.171.37]) by hermes.gg.sterlingdi.com (8.9.3/8.9.3/SuSE Linux 8.9.3-0.1) with ESMTP id JAA31693 for ; Mon, 20 Dec 1999 09:59:41 -0500 Received: from guinness (guinness.eng.ironhilltech.com [192.168.140.230]) by brewmaster.eng.ironhilltech.com (8.9.3/8.9.3) with SMTP id KAA19178 for ; Mon, 20 Dec 1999 10:08:04 -0500 Message-ID: <005001bf4afa$f97d6f90$e68ca8c0@eng.ironhilltech.com> From: "Dan Linderman" To: Subject: Inheriting Primary Keys Date: Mon, 20 Dec 1999 10:00:37 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-Mimeole: Produced By Microsoft MimeOLE V5.00.2314.1300 A coworker recently was playing with inheritance in PostgreSQL, and noticed that Primary Keys were not inhetited by child tables. He created a parent table with a Primary Key, then created a tabel to inhetir the parent, but the unique constraint of the primary key was not passed on. Is this a known occurance? If so, how do we enforce the uniqueness of the inherited column? Dan Linderman Web Programmer Iron Hill Technology linderdm@ironhilltech.com 302-369-9750 x23 www.ironhilltech.com