Re: Inheritance and Constraint - Mailing list pgsql-general

From Chris
Subject Re: Inheritance and Constraint
Date
Msg-id 39B6CD0B.69D98AC5@nimrod.itg.telecom.com.au
Whole thread Raw
In response to Inheritance and Constraint  (Alexandre FLAMENT <_alf@caramail.com>)
List 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.

pgsql-general by date:

Previous
From: "Martin A. Marques"
Date:
Subject: postgresql-7.0.2 rpms
Next
From: Oliver Smith
Date:
Subject: Re: That killer 3rd join...