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

[ZhangJulian <jul...@ou...>]

Hi,

You should create t3 ... distribute by replication or distribute by hash(b), if you want define a primary key on column b.

postgres=# create table t2
(a int) DISTRIBUTE BY REPLICATION ;
CREATE TABLE
Time: 86.475 ms
postgres=# CREATE TABLE t3
( b int not null CONSTRAINT PK_t3 primary key,
c int)
INHERITS(t2) distribute by replication;
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pk_t3" for table "t3"
CREATE TABLE
Time: 174.161 ms
postgres=# CREATE TABLE t4
( b int not null CONSTRAINT PK_t4 primary key,
c int)
INHERITS(t2) distribute by hash(b);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pk_t4" for table "t4"
CREATE TABLE
Time: 177.739 ms


Thanks
Julian

Date: Thu, 16 Jan 2014 12:54:06 -0800
From: yin...@ya...
To: pos...@li...
Subject: [Postgres-xc-bugs] ERROR: Cannot create index whose evaluation	cannot be enforced to remote nodes

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