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

Partitioning syntax

From: Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Partitioning syntax
Date: 2010-01-14 09:13:23
Message-ID: 20100114181323.9A33.52131E4D@oss.ntt.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
Here is a revised partitioning syntax patch. It implements only syntax and
on-disk structure mentioned below:
    Table Partitioning#Syntax
      http://wiki.postgresql.org/wiki/Table_partitioning#Syntax
    Table Partitioning#On-disk structure
      http://wiki.postgresql.org/wiki/Table_partitioning#On-disk_structure

What we can do with the patch is src/test/regress/sql/partition.sql.
Note that the patch does nothing about INSERTs; triggers are still needed.

The main syntax is CREATE TABLE () PARTITION BY {RANGE | LIST} (...).
The reason I use it rather than "PARTITIONED BY" is for compatibility
to other DBMSs; Oracle and MySQL.

Changes from the previous CommitFest are:
 - Additinal regression tests:
   1000 partitions, error cases and boolean partitions
 - Use pg_inherits_parent_index index if available.
 - Sort not only range partitions but also list partitions
   for stable display order.
 - Remove ALTER PARTITION and DROP PARTITION syntax because
   they are just synonyms of ALTER TABLE and DROP TABLE.

Regards,
---
Takahiro Itagaki
NTT Open Source Software Center

Attachment: partitioning-syntax_20100114.patch
Description: application/octet-stream (143.5 KB)

Responses

pgsql-hackers by date

Next:From: KaiGai KoheiDate: 2010-01-14 09:22:35
Subject: Re: [PATCH] remove redundant ownership checks
Previous:From: Fujii MasaoDate: 2010-01-14 09:02:46
Subject: Re: Streaming replication and non-blocking I/O

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