On Tuesday 18 June 2002 16:19, I wrote:
> 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)
John Taylor J T Response Limited
Director Internet Solutions for Business
+44 (0)1954 261146
In response to
pgsql-novice by date
|Next:||From: Pierre-Alexis PAQUIN||Date: 2002-06-18 16:02:00|
|Subject: unsubscribe NOVICE|
|Previous:||From: Josh Berkus||Date: 2002-06-18 15:36:15|
|Subject: Re: Which indexes to drop|