Re: [Postgres-xc-developers] try install MOODLE using postgresxc

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

On Thu, Aug 1, 2013 at 6:14 PM, Afonso Bione <aag...@gm...> wrote:

> Dear friends,
>
> I´d like to ask your help once again to continue the installation of
> Moodle,
> I just created the database in all nodes successfully. But In moodle
> installation got this error message:
>
> *Debug info:* ERROR: Cannot create index whose evaluation cannot be
> enforced to remote nodes
> CREATE UNIQUE INDEX mdl_conf_nam_uix ON mdl_config (name)
>
Change the distribution of your table. In XC, a unique index evaluation
needs to be done at the Datanode level and cannot be done on Coordinators.
So in this case, you need either to change mdl_conf_nam_uix to a replicated
table (in this case you impact performance, but create all kinds of
indexes), or have its distribution key set up as "name" to be sure that the
uniqueness of a given column value is evaluated on a single remote Datanode.
-- 
Michael