Received: from styx.apartia.int (postfix@dyn-1-1-105.Vin.dialup.oleane.fr
	[195.25.4.105]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA61686
	for <pgsql-general@postgresql.org>; Sat, 3 Jun 2000 11:23:02 -0400 (EDT)
	(envelope-from cunctator@apartia.ch)
Received: by styx.apartia.int (Postfix, from userid 1000)
	id 7066D44C6; Sat,  3 Jun 2000 17:22:56 +0200 (CEST)
Date: Sat, 3 Jun 2000 17:22:56 +0200
From: Louis-David Mitterrand <cunctator@apartia.ch>
To: pgsql-general@postgresql.org
Subject: child table doesn't inherit PRIMARY KEY?
Message-ID: <20000603172256.A3435@styx>
Reply-To: ldm@apartia.com
Mail-Followup-To: pgsql-general@postgresql.org
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2i
X-Archive-Number: 200006/93

When creating a child (through CREATE TABLE ... INHERIT (parent)) it
seems the child gets all of the parent's contraints _except_ its PRIMARY
KEY. Is this normal? Should I add a PRIMARY KEY(id) statement each time
I create an inherited table?

Cheers,

-- 
Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.fr

If at first you don't succeed, redefine success.