Re: Auto creation of Partitions

Hi,

On 3/9/07, Shane Ambler <pgsql(at)sheeky(dot)biz> wrote:
>
>
> > Note to Nikhil: Make sure the new syntax doesn't prevent partitions from
> > being placed upon multiple tablespaces in some manner, at CREATE TABLE
> > time.
>
> What if the syntax was something like -
>
> CREATE TABLE tabname (
> ...
> ...
> ) PARTITION BY
> HASH(expr)
> | RANGE(expr)
> | LIST(expr)
> [PARTITIONS num_partitions] /* will apply to HASH only for now*/
> [PARTITION partition_name CHECK(...) [USING TABLESPACE tblspcname],
> PARTITION partition_name CHECK(...) [USING TABLESPACE tblspcname]
> ...
> ];
>
>
> And (if we use the ALTER TABLE to add partitions)
>
> ALTER TABLE tabname
> ADD PARTITION partition_name CHECK(...)
> [USING TABLESPACE tblspcname];
>
>
We could as well drop the USING part.

Regards,
Nikhils
--
EnterpriseDB http://www.enterprisedb.com