Skip site navigation (1) Skip section navigation (2)

Re: INHERITANCE

From: Chris <chrisb(at)nimrod(dot)itg(dot)telstra(dot)com(dot)au>
To: "Trewern, Ben" <Ben(dot)Trewern(at)mowlem(dot)com>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: INHERITANCE
Date: 2000-08-31 22:41:09
Message-ID: 39AEDF05.55F05A38@nimrod.itg.telecom.com.au (view raw or flat)
Thread:
Lists: 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.

In response to

pgsql-general by date

Next:From: Ian TurnerDate: 2000-09-01 00:44:05
Subject: referential integrity
Previous:From: Campbell, ScottDate: 2000-08-31 19:23:39
Subject: more problems with transactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group