Postgres Pro
Downloads
Home   >   mailing lists

Re: What gets inherited - Mailing list pgsql-novice

From John Taylor
Subject Re: What gets inherited
Date
Msg-id 02061816452703.01632@splash.hq.jtresponse.co.uk
Whole thread Raw
In response to What gets inherited  (John Taylor <postgres@jtresponse.co.uk>)
List pgsql-novice
Tree view 
On Tuesday 18 June 2002 16:19, I wrote:
> Hi,
>
> If I create a table that inherits from another, it inherits all the attributes,
> but does not appear to inherit the constraints, or indexes
>

Just double checked.
It seems that indexes DO get inherited, but I'm not sure about the rest.
(I don't think I had enough rows for the optimizer to kick in indexed searches before)

Regards
JohnT

--
John Taylor            J T Response Limited
Director               Internet Solutions for Business
                       +44 (0)1954 261146

pgsql-novice by date:

Previous
From: Steven Blundy
Date:
Subject: Opaque not working as documented
Next
From: Tien Tran Ngoc
Date:
Subject: ISAM access in PostgreSQL?