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

[Aaron J. <aja...@re...>]

Yes, I completely understand why it has to be done.  I was working with an in-memory distributed database earlier this year and they allowed constraints like these as long as the constraint included the partitioned / distributed key.  In theory, I guess that's viable because it means that the data node alone be capable of guaranteeing uniqueness without any further coordination.

I'll try adding a unique index post creation to see if it works.

Thank you

________________________________
From: 鈴木 幸市 [ko...@in...]
Sent: Tuesday, April 15, 2014 7:54 PM
To: Aaron Jackson
Cc: pos...@li...
Subject: Re: [Postgres-xc-general] Creating Unique Indices

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