Thread

1. Inheritance and Constraint

   Alexandre FLAMENT <_alf@caramail.com> — 2000-09-06T15:01:39Z

   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
   
   
   

2. Re: Inheritance and Constraint

   Chris Bitmead <chrisb@nimrod.itg.telstra.com.au> — 2000-09-06T23:02:35Z

   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.