Received: from candle.pha.pa.us (pgman@nav-43.dsl.navpoint.com
 [162.33.245.46])
	by hub.org (8.10.1/8.10.1) with ESMTP id e92GTvD10218
	for <pgsql-general@postgresql.org>; Mon, 2 Oct 2000 12:29:58 -0400 (EDT)
Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id
 MAA23736;
	Mon, 2 Oct 2000 12:29:34 -0400 (EDT)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200010021629.MAA23736@candle.pha.pa.us>
Subject: Re: child table doesn't inherit PRIMARY KEY?
In-Reply-To: <Pine.LNX.4.21.0006040341030.348-100000@localhost.localdomain>
	"from Peter Eisentraut at Jun 4, 2000 03:46:53 am"
To: Peter Eisentraut <peter_e@gmx.net>
Date: Mon, 2 Oct 2000 12:29:34 -0400 (EDT)
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: 200010/18

Can someone comment on this?

[ 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