Thread: Inheritance and Constraint

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 ?
______________________________________________________
Boîte aux lettres - Caramail - http://www.caramail.com

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.