Re: child table doesn't inherit PRIMARY KEY? - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: child table doesn't inherit PRIMARY KEY?
Date
Msg-id 393A0881.E1AC056D@tm.ee
Whole thread Raw
In response to child table doesn't inherit PRIMARY KEY?  (Louis-David Mitterrand <cunctator@apartia.ch>)
List pgsql-hackers
Louis-David Mitterrand wrote:
> 
> Solutions:
> 
> 1) don't use PRIMARY KEY, use UNIQUE NOT NULL (which will be inherited?)
> but the I lose the index,

AFAIK the UNIQUE constraint is implemented in PostgreSQL by creating 
an unique index on that field 

----------
Hannu


pgsql-hackers by date:

Previous
From: Louis-David Mitterrand
Date:
Subject: child table doesn't inherit PRIMARY KEY?
Next
From: Denis Perchine
Date:
Subject: Problem upgrading from 7.0 to 7.0.1