Skip site navigation (1) Skip section navigation (2)

Re: Auto creation of Partitions

From: NikhilS <nikkhils(at)gmail(dot)com>
To: "Gregory Stark" <stark(at)enterprisedb(dot)com>
Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Auto creation of Partitions
Date: 2007-03-06 14:11:41
Message-ID: d3c4af540703060611i51125ef9y4e07db37dfb5b8d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Hi,

On 3/6/07, Gregory Stark <stark(at)enterprisedb(dot)com> wrote:
>
> "NikhilS" <nikkhils(at)gmail(dot)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.


Yeah, this one aims to do pretty much the above as part of the auto creation
of the inheritance-based partitions.

Regards,
Nikhils


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



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

In response to

Responses

pgsql-hackers by date

Next:From: NikhilSDate: 2007-03-06 14:13:58
Subject: Re: Auto creation of Partitions
Previous:From: Gregory StarkDate: 2007-03-06 13:57:56
Subject: Re: Auto creation of Partitions

pgsql-patches by date

Next:From: NikhilSDate: 2007-03-06 14:13:58
Subject: Re: Auto creation of Partitions
Previous:From: Gregory StarkDate: 2007-03-06 13:57:56
Subject: Re: Auto creation of Partitions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group