Re: [Postgres-xc-general] Creating Unique Indices

[鈴木 幸市 <ko...@in...>]

It is in the list of the future work.   To enforce this, we need cross-node operation which need additional infrastructure.   So at present, you can add unique index to distributed table if distribution column is involved.    You can add unique index freely to replicated tables.

For the same reason, you cannot add reference integrity between distributed tables.

Regards;
---
Koichi Suzuki

2014/04/16 4:36、Aaron Jackson <aja...@re...<mailto:aja...@re...>> のメール：

Is there any capability to create unique indices where one part of the constraint is the distribution key.  In theory, if I created distributed on column name, but then created a unique index on name + level, the constraint could be applied at the data node level.

Aaron
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech_______________________________________________
Postgres-xc-general mailing list
Pos...@li...
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general