Re: table inheritance - Mailing list pgsql-general

From Stephan Szabo
Subject Re: table inheritance
Date
Msg-id Pine.BSF.4.21.0105310833020.11460-100000@megazone23.bigpanda.com
Whole thread Raw
In response to table inheritance  (Renaud Thonnart <thonnart@amwdb.u-strasbg.fr>)
Responses Re: table inheritance
List pgsql-general
On Thu, 31 May 2001, Renaud Thonnart wrote:

> Hi all!
>
> I would like to know if a table that inherits an other does also inherit
> of the constraints,triggers,...  of the parent table because it is not
> mentioned in the PostgreSQL guide.

AFAIK, Not null and Check constraints are inherited.  Unique, Primary Key,
Foreign Key and user triggers are not.


pgsql-general by date:

Previous
From: Renaud Thonnart
Date:
Subject: Re: table inheritance
Next
From: Gerald Gutierrez
Date:
Subject: Re: dumping strategy