Re: Inheritance and Constraint

Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>

From: Chris <chrisb@nimrod.itg.telstra.com.au>
To: Alexandre FLAMENT <_alf@caramail.com>
Cc: pgsql-general@postgresql.org
Date: 2000-09-06T23:02:35Z
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.