Re: INHERITANCE - Mailing list pgsql-general

From Chris
Subject Re: INHERITANCE
Date
Msg-id 39AEDF05.55F05A38@nimrod.itg.telecom.com.au
Whole thread Raw
In response to INHERITANCE  ("Trewern, Ben" <Ben.Trewern@mowlem.com>)
List pgsql-general
> "Trewern, Ben" wrote:
>
> I have just been trying out
>
> Create Table .. Inherits ( ..);
>
> Am I right in saying you create a table that inherits fields & default
> values, but not triggers.
>
> I have not tried rules or anything else yet.  Where can I read more
> about inheritance and where to use it.

I think only fields and default values are inherited. Ideally everything
would be inherited unless you specify otherwise, like indexes, rules etc
etc, but currently that is not implemented. The manual is the place to
start with regards these features.

pgsql-general by date:

Previous
From: "Campbell, Scott"
Date:
Subject: more problems with transactions
Next
From: Ian Turner
Date:
Subject: Re: POSTGRESQL vs. ORACLE 8i &Sybase & Interbase etc