Received: from hu.tm.ee (IDENT:postfix@adsl22.uninet.ee [194.204.62.22])
	by hub.org (8.9.3/8.9.3) with ESMTP id FAA18903
	for <pgsql-hackers@postgresql.org>;
	Mon, 22 May 2000 05:24:25 -0400 (EDT) (envelope-from hannu@tm.ee)
Received: from tm.ee (localhost [127.0.0.1]) by hu.tm.ee (Postfix) with ESMTP
	id 8BA8A38CE; Mon, 22 May 2000 11:30:19 +0300 (EEST)
Message-ID: <3928F01B.B0C6D563@tm.ee>
Date: Mon, 22 May 2000 11:30:19 +0300
From: Hannu Krosing <hannu@tm.ee>
Organization: Trust-O-Matic =?iso-8859-1?Q?O=DC?=
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13-7mdk i686)
X-Accept-Language: et, en
MIME-Version: 1.0
To: Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>
Cc: Chris Bitmead <chris@bitmead.com>,
	"Robert B. Easter" <reaster@comptechnews.com>,
	Peter Eisentraut <peter_e@gmx.net>,
	PostgreSQL Development <pgsql-hackers@postgresql.org>
Subject: Re: Thus spoke SQL3 (on OO)
References: <Pine.LNX.4.21.0005201507330.423-100000@localhost.localdomain>
	<00052104000003.14806@comptechnews> <392830DA.B5546EF7@bitmead.com>
	<00052108053904.14806@comptechnews>
	<39286B3F.F4594E40@bitmead.com> <39283008.ED83E94@tm.ee>
	<39287873.D023D7E5@nimrod.itg.telecom.com.au>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200005/436

Chris Bitmead wrote:
> 
> Hannu Krosing wrote:
> 
> > Chris, what is your position on having a single primary key for all
> > inherited columns ?
> 
> What is the significance of a primary key compared to any old unique
> key?

I don't know ;) Some theorists seem to think it important, and PG allows 
only one PK per table.

I just meant that primary key (as well as any other uniqe key) should be 
inherited from parent table

------------------
Hannu