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