Re: Auto creation of Partitions - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: Auto creation of Partitions
Date
Msg-id 87fy8ibhjv.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Auto creation of Partitions  (NikhilS <nikkhils@gmail.com>)
Responses Re: Auto creation of Partitions  (NikhilS <nikkhils@gmail.com>)
List pgsql-hackers
"NikhilS" <nikkhils@gmail.com> 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.


--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: "Mike Rylander"
Date:
Subject: Re: [PATCHES] xml2 contrib patch supporting default XML namespaces
Next
From: NikhilS
Date:
Subject: Re: Auto creation of Partitions