Horton

Re: Thus spoke SQL3 (on OO)

Hannu Krosing <hannu@tm.ee>

View thread
From: Hannu Krosing <hannu@tm.ee>
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>
Date: 2000-05-22T08:30:19Z
Lists: pgsql-hackers 
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