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:13:58 |
Message-ID: | d3c4af540703060613r355897b7ya24aec168bf109eb@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On 3/6/07, NikhilS <nikkhils(at)gmail(dot)com> wrote:
>
> 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.
>
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew - Supernews | 2007-03-06 14:53:15 | Re: GIST and TOAST |
Previous Message | NikhilS | 2007-03-06 14:11:41 | Re: Auto creation of Partitions |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-03-06 14:15:28 | Re: Heap page diagnostic/test functions (WIP) |
Previous Message | NikhilS | 2007-03-06 14:11:41 | Re: Auto creation of Partitions |