Received: from candle.pha.pa.us (candle.navpoint.com [162.33.245.46]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0J4vU055167 for ; Thu, 18 Jan 2001 23:57:30 -0500 (EST) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id XAA13895; Thu, 18 Jan 2001 23:57:07 -0500 (EST) From: Bruce Momjian Message-Id: <200101190457.XAA13895@candle.pha.pa.us> Subject: Re: child table doesn't inherit PRIMARY KEY? In-Reply-To: "from Peter Eisentraut at Jun 4, 2000 03:46:53 am" To: Peter Eisentraut Date: Thu, 18 Jan 2001 23:57:07 -0500 (EST) CC: ldm@apartia.com, pgsql-general@postgresql.org X-Mailer: ELM [version 2.4ME+ PL77 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200101/891 X-Sequence-Number: 3115 Does this bug still exist? [ Charset ISO-8859-1 unsupported, converting... ] > 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. > > > -- > Peter Eisentraut Sernanders v?g 10:115 > peter_e@gmx.net 75262 Uppsala > http://yi.org/peter-e/ Sweden > > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026