Re: Partitioning feature ...

Hi Kedar,

>
>
> The syntax used conforms to most of the suggestions mentioned in
> http://archives.postgresql.org/pgsql-hackers/2008-01/msg00413.php, barring
> the following:
> -- Specification of partition names is optional. System will be able to
> generate partition names in such cases.
> -- Sub partitioning
>

I was wondering if there is a need to mention the type of partition while
dropping it.

E.g
ALTER table x DROP RANGE PARTITION x_part;

The type of partition (RANGE, HASH) could be dropped according to me.

>
> We are maintaining a system catalog(pg_partition) for partition meta-data.
> System will look-up this table to find appropriate partition to operate on.
> System internally uses low-level 'C' triggers to row-movement.
>

Can you elaborate more on how do you handle updates with these triggers?

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