On Thu, Nov 12, 2009 at 5:54 AM, Itagaki Takahiro
<itagaki.takahiro@oss.ntt.co.jp> wrote:
> I added psql and pg_dump support to Partitioning Syntax patch.
> Paritioning information can be retrieved with a new system function
> pg_get_partitiondef(parentRelid). Both psql and pg_dump use it.
>
i haven't seen the patch but:
>
> * If a table with the same name already exists when a partition
> is created, the table is re-used as partition. This behavior
> is required for pg_dump to be simple.
>
i guess the table must be empty, if not we should be throw an error...
and i actually prefer some more explicit syntax for this not just
reusing a table
> PARTITION name VALUES LESS THAN { range_upper | MAXVALUE }
> | PARTITION name VALUES IN ( list_value [,...] | DEFAULT )
>
i remember someone making a comment about actually using operators
instead of LESS THEN and family
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
