| From: | Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | Dmitry Fefelov <fozzy(at)ac-sw(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Partitioning syntax |
| Date: | 2010-03-17 08:13:50 |
| Message-ID: | 20100317171349.8F83.52131E4D@oss.ntt.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Dmitry Fefelov <fozzy(at)ac-sw(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gokulakannan Somasundaram | 2010-03-17 08:30:12 | Re: Bug in 9.0Alpha4 |
| Previous Message | Dmitry Fefelov | 2010-03-17 07:55:45 | Re: Partitioning syntax |