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

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

It is what we’d like to have in the next release.  I’m planning to discuss next XC major feature in XC days in Ottawa, May.   This meeting will be held as one of the PGCon-related meetings.   This is definitely the one we want to have, as well as enforcing cross-node referential constraint.

Thank you.
---
Koichi Suzuki

2014/04/16 15:53、Aaron Jackson <aja...@re...<mailto: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...<mailto:ko...@in...>]
Sent: Tuesday, April 15, 2014 7:54 PM
To: Aaron Jackson
Cc: pos...@li...<mailto: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...<mailto:Pos...@li...>
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general