From: | NikhilS <nikkhils(at)gmail(dot)com> |
---|---|
To: | "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at> |
Cc: | "Peter Eisentraut" <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Auto creation of Partitions |
Date: | 2007-03-07 14:29:48 |
Message-ID: | d3c4af540703070629s7f475700n34990ef0438112ee@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Hi,
On 3/7/07, Zeugswetter Andreas ADI SD <ZeugswetterA(at)spardat(dot)at> wrote:
>
>
> > > iv) Based on the PRIMARY, UNIQUE, REFERENCES information specified,
> > > pass it on to the children tables.
> >
> > How will you maintain a primary key in such a table,
> > considering that indexes can't span multiple tables?
>
> Many partitioning schemes have (or can be made to have) only one
> possible target partition for the primary key. Thus if you create
> separate unique indexes on each partition the problem is solved.
> For a first version I opt, that it is sufficient to disallow creation of
> a unique index on the master, when the constraints (on columns of this
> index) do not nail down a specific partition for each row (e.g. a hash
> or a range on one of the index columns that does not overlap).
> Later, global index, or indexes with separate partitioning rules can be
> implemented, that cover the other cases.
>
> Andreas
>
Yes, I agree. For version 1, UNIQUE/PRIMARY indexes will cascade down to the
child table, only if the indexed column is present as part of the
partitioning rule.
Regards,
Nikhils
--
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas ADI SD | 2007-03-07 14:52:45 | Re: Patch license update to developer's FAQ |
Previous Message | Luke Lonergan | 2007-03-07 14:02:01 | Re: Grouped Index Tuples / Clustered Indexes |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2007-03-07 14:58:32 | Re: Auto creation of Partitions |
Previous Message | Zeugswetter Andreas ADI SD | 2007-03-07 13:34:16 | Re: Auto creation of Partitions |