[Postgres-xc-general] ERROR: Cannot create foreign key whose evaluation cannot be enforced to remote nodes

[Alex H. <ale...@au...>]

Hi guys,

 

I could really use your help. 
I'm a sysadmin. I'm not a DBA, and I don't have any experience with
PostgreSQL.
 
I'm trying PGXC as a Cluster solution for the PGSQL DB Component in our
Car's assistance infrastructure.
The problem I'm currently having, is that when I try to set a foreign key in
any table.
 
"ERROR:  Cannot create foreign key whose evaluation cannot be enforced to
remote nodes"
 
Koichi Suzuki says that this is current XC limitation, I tried to Change the
tables distribution to "replication". I can change the layout, but the
problem is when I want to add the foreign key, I get the same error. How can
I do to have the keys in my system?
The system has at least 10 nodes. 
 
Regards,

 

Alex Hudson S.