Re: child table doesn't inherit PRIMARY KEY?

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: ldm(at)apartia(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: child table doesn't inherit PRIMARY KEY?
Date: 2000-06-04 07:42:57
Message-ID: 393A0881.E1AC056D@tm.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Denis Perchine 2000-06-04 10:06:05 Problem upgrading from 7.0 to 7.0.1
Previous Message Louis-David Mitterrand 2000-06-04 07:20:16 Re: child table doesn't inherit PRIMARY KEY?