Hi, On 3/9/07, Shane Ambler <[EMAIL PROTECTED]> 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