Re: Inheritance and unique constraints

On Wed, 05 Jul 2006 15:51:23 +0200
"Christian Rengstl" <Christian.Rengstl@klinik.uni-regensburg.de> wrote:

> Hi everyone,
>
> i hope (and i'm sure) somebody can answer my question: if i have a
> master table and several "child" tables, do the child tables inherit
> the unique constraint(s) defined for the master table or do i have to
> define the same constraints for the same fields in all the child
> tables?
>
> Thanks!
>
> --
> Christian Rengstl M.A.
> Klinik und Poliklinik für Innere Medizin II
> Kardiologie - Forschung
> Universitätsklinikum Regensburg
> B3 1.388
> Franz-Josef-Strauss-Allee 11
> 93053 Regensburg
> Tel.: +49-941-944-7230
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 9: In versions below 8.0,
> the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match

As of 8.1.0 UNIQUE constraints are not inherited.  See page 62 of the
documentation.

John Purser

--
Courage is your greatest present need.