<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent changes to 5: v1.2 ERROR:  Cannot create index whose evaluation cannot be enforced to remote nodes</title><link href="https://sourceforge.net/p/postgres-xc/support-requests/5/" rel="alternate"/><link href="https://sourceforge.net/p/postgres-xc/support-requests/5/feed.atom" rel="self"/><id>https://sourceforge.net/p/postgres-xc/support-requests/5/</id><updated>2014-06-27T20:50:08.676000Z</updated><subtitle>Recent changes to 5: v1.2 ERROR:  Cannot create index whose evaluation cannot be enforced to remote nodes</subtitle><entry><title>v1.2 ERROR:  Cannot create index whose evaluation cannot be enforced to remote nodes</title><link href="https://sourceforge.net/p/postgres-xc/support-requests/5/" rel="alternate"/><published>2014-06-27T20:50:08.676000Z</published><updated>2014-06-27T20:50:08.676000Z</updated><author><name>Mike</name><uri>https://sourceforge.net/u/swampfoxmr/</uri></author><id>https://sourceforge.net7dd34ddc872a933df2e1684a0ba69f9d2b04655a</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Create index for table cddos generates error message (I have no idea what it means or where to look for meaning). The only thing I can think of is that there are more fields in the index than in the key?&lt;/p&gt;
&lt;p&gt;Index create:&lt;br /&gt;
CREATE UNIQUE INDEX cidos1 ON cddos USING btree (cunges, ndomat, netima);&lt;/p&gt;
&lt;p&gt;Table definition:&lt;br /&gt;
 CREATE TABLE cddos (&lt;br /&gt;
 ndomat numeric(7,0) NOT NULL,&lt;br /&gt;
 netima numeric(1,0) NOT NULL,&lt;br /&gt;
 ndopfe character(15) NOT NULL,&lt;br /&gt;
 clcndo character(1) NOT NULL,&lt;br /&gt;
 didaff numeric(9,0) NOT NULL,&lt;br /&gt;
 dlvcpr numeric(9,0) NOT NULL,&lt;br /&gt;
 ciuges character(2) NOT NULL,&lt;br /&gt;
 d1odpl numeric(9,0) NOT NULL,&lt;br /&gt;
 csesoc character(4) NOT NULL,&lt;br /&gt;
 capres character(2) NOT NULL,&lt;br /&gt;
 dmcdos numeric(9,0) NOT NULL,&lt;br /&gt;
 cstacp character(1) NOT NULL,&lt;br /&gt;
 cunges character(7) NOT NULL,&lt;br /&gt;
 cmetra character(1) NOT NULL,&lt;br /&gt;
 danars numeric(9,0) NOT NULL,&lt;br /&gt;
 ddecra numeric(9,0) NOT NULL,&lt;br /&gt;
 dnotpa numeric(9,0) NOT NULL,&lt;br /&gt;
 ddecal numeric(9,0) NOT NULL,&lt;br /&gt;
 dmocgm numeric(9,0) NOT NULL,&lt;br /&gt;
 dapres numeric(9,0) NOT NULL,&lt;br /&gt;
 dreres numeric(9,0) NOT NULL,&lt;br /&gt;
 dmajdo numeric(9,0) NOT NULL,&lt;br /&gt;
 dndpot numeric(9,0) NOT NULL,&lt;br /&gt;
 confid character(4) NOT NULL,&lt;br /&gt;
 coeffk character(1) NOT NULL,&lt;br /&gt;
 corgim character(3) NOT NULL,&lt;br /&gt;
 confor character(1) NOT NULL,&lt;br /&gt;
 doheix numeric(9,0) NOT NULL,&lt;br /&gt;
 ctimco character(2) NOT NULL,&lt;br /&gt;
 depaje numeric(9,0) NOT NULL,&lt;br /&gt;
 daplma numeric(9,0) NOT NULL,&lt;br /&gt;
 dbarsa numeric(9,0) NOT NULL,&lt;br /&gt;
 ctybas character(1) NOT NULL,&lt;br /&gt;
 dmjdcp numeric(9,0) NOT NULL,&lt;br /&gt;
 hmjdcp numeric(7,0) NOT NULL,&lt;br /&gt;
 CONSTRAINT cidos0 PRIMARY KEY (ndomat, netima)&lt;br /&gt;
 )&lt;br /&gt;
 DISTRIBUTE BY HASH (ndomat);&lt;/p&gt;
&lt;p&gt;psql:run_alter.txt:1: ERROR:  Cannot create index whose evaluation cannot be enforced to remote nodes&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>