Received: from styx.apartia.int (postfix@dyn-1-1-194.Vin.dialup.oleane.fr [195.25.4.194]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA43005 for ; Sun, 4 Jun 2000 03:20:18 -0400 (EDT) (envelope-from cunctator@apartia.ch) Received: by styx.apartia.int (Postfix, from userid 1000) id 237175156; Sun, 4 Jun 2000 09:20:16 +0200 (CEST) Date: Sun, 4 Jun 2000 09:20:16 +0200 From: Louis-David Mitterrand To: Peter Eisentraut Cc: pgsql-general@postgresql.org Subject: Re: child table doesn't inherit PRIMARY KEY? Message-ID: <20000604092015.A6240@styx> Reply-To: ldm@apartia.com Mail-Followup-To: Peter Eisentraut , pgsql-general@postgresql.org References: <20000603172256.A3435@styx> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2i In-Reply-To: ; from peter_e@gmx.net on Sun, Jun 04, 2000 at 03:46:53AM +0200 X-Archive-Number: 200006/101 On Sun, Jun 04, 2000 at 03:46:53AM +0200, Peter Eisentraut wrote: > Louis-David Mitterrand writes: > > > 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? > > It's kind of a bug. Is it a well-known bug or have I discovered it? ;-) (I am sending a copy of the bug report to -hackers) Thanks, -- Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.fr "God is a mathematician of very high order, and he used very advanced mathematics in constructing the universe." (Dirac)