| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Turner | 2000-09-01 00:44:05 | referential integrity |
| Previous Message | Campbell, Scott | 2000-08-31 19:23:39 | more problems with transactions |