On 3/6/07, NikhilS <[EMAIL PROTECTED]> wrote:
Hi, On 3/6/07, Gregory Stark <[EMAIL PROTECTED]> wrote: > > "NikhilS" <[EMAIL PROTECTED]> writes: > > >the intention is to use this information from the parent and make it a > >property of the child table. This will avoid the step for the user > having to > >manually specify CREATE INDEX and the likes on all the children tables > >one-by-one. > > Missed the start of this thread. A while back I had intended to add WITH > INDEXES to CREATE TABLE LIKE. That would let you create a tale LIKE > parent > WITH CONSTRAINTS WITH INDEXES and get pretty much a perfect table ready > for > adding to the inheritance structure. Yeah, this one aims to do pretty much the above as part of the auto creation of the inheritance-based partitions.
And to add, maybe if there is consensus/demand for the WITH INDEXES idea mentioned above too, I could work on it as well. Regards, Nikhils Regards,
Nikhils -- > Gregory Stark > EnterpriseDB http://www.enterprisedb.com > -- EnterpriseDB http://www.enterprisedb.com
-- EnterpriseDB http://www.enterprisedb.com