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.