Re: Partitioning syntax

Dmitry Fefelov <fozzy@ac-sw.com> wrote:

> > 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
> 
> Will 9.1 partitions allow to reference partitioned tables in foreign keys?

Not in my first goals, but it might be possible if we could support row locks
for UNION plans:

=# SELECT * FROM tbl1 UNION ALL SELECT * FROM tbl2 FOR SHARE;
ERROR:  SELECT FOR UPDATE/SHARE is not allowed with UNION/INTERSECT/EXCEPT
(in 9.0)

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