Re: Inheritance and Constraint

From: Chris <chrisb(at)nimrod(dot)itg(dot)telstra(dot)com(dot)au>
To: Alexandre FLAMENT <_alf(at)caramail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Inheritance and Constraint
Date: 2000-09-06 23:02:35
Message-ID: 39B6CD0B.69D98AC5@nimrod.itg.telecom.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alexandre FLAMENT wrote:
>
> I made a table contenu, with idcontenu (of type serial) as
> primary key. A second table (image) inherits of contenu. The
> problem is the primary wasn't apply to the table image : I
> can insert two rows the same idcontenu. Is it normal ? How
> can I propagate the constraint ?

This is because unfortunately indexes are not currently inherited.
Everyone knows that they should be, but no-one has got around to
implementing it yet.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Smith 2000-09-07 00:11:10 Re: That killer 3rd join...
Previous Message Gary MacDougall 2000-09-06 21:02:55 Re: post installation error