Inheritance and unique constraints

From: "Christian Rengstl" <Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Inheritance and unique constraints
Date: 2006-07-05 13:51:23
Message-ID: 44ABDFFB.0AD0.0080.0@klinik.uni-regensburg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Szymic1 2006-07-05 14:12:02 How to hide NOTICE messages in psql.exe ?
Previous Message tommaso.gastaldi 2006-07-05 13:33:34 Re: OLEDB connection does not want to work. Help!!