Re: [Postgres-xc-bugs] ERROR: Cannot create index whose evaluation cannot be enforced to remote nodes

[Koichi S. <koi...@gm...>]

Inherits option from t2 to t3 enforces the column a as the
distribution column.   Current XC does not allow primary key (or
unique constraint) to a column other than the distribution key.

Regards;
---
Koichi Suzuki


2014/1/17 Ying He <yin...@ya...>:
> hi, All,
>
> I setup the following for testing:
>
> host1 has gtm master
> host2 has gtm slave
> host3 has gtm_proxy1, coordinator1, datanode1
> host4 has gtm_proxy2, coordinator2, datanode2
>
> once it is up and running, i connect to coordinator1 to do the following:
>
> create table t2
> (a int) DISTRIBUTE BY REPLICATION ;
>
> CREATE TABLE t3
> ( b int not null CONSTRAINT PK_t3 primary key,
> c int)
> INHERITS(t2);
>
> will produce
> ERROR:  Cannot create index whose evaluation cannot be enforced to remote
> nodes
>
> looks like the INHERITS is not supported.
>
> Please help if you see anything wrong. Thank you.
>
> best,
> Ying
>
>
> ------------------------------------------------------------------------------
> CenturyLink Cloud: The Leader in Enterprise Cloud Services.
> Learn Why More Businesses Are Choosing CenturyLink Cloud For
> Critical Workloads, Development Environments & Everything In Between.
> Get a Quote or Start a Free Trial Today.
> http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-bugs mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-bugs
>