Re: [Postgres-xc-developers] Doubt with the distribution of composite indices.

[Michael P. <mic...@gm...>]

On Wed, Aug 28, 2013 at 10:18 PM, Afonso Bione <aag...@gm...> wrote:
> Dear Postgres-XC menbers,
>
> I have this index
> CREATE UNIQUE INDEX ON mdl_backidstemp_baciteite_uix mdl_backup_ids_template
> USING btree (backupid, itemname, itemid) and I would like to convert it to the postgres-xc
OK, there are two things here:
1) this CREATE INDEX query is written incorrectly, you need to define
the index name after the keyword INDEX, so... it should be written
like that:
CREATE UNIQUE INDEX mdl_backidstemp_baciteite_uix ON
mdl_backup_ids_template USING btree (backupid, itemname, itemid);
2) If you want to create a unique index like that on table
mdl_backup_ids_template, its distribution column needs be be either
backupid, itemname or itemid.
-- 
Michael