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

[Ashutosh B. <ash...@en...>]

Hi Alex,
The error comes because, the referenced key is not guaranteed to on the
same node where the row referencing it lies. Thus either of following
should hold for adding a foreign key.
1. Both the tables (referenced and referencer) should be replicated on the
same set of nodes
2. Both the tables should be distributed by in the same fashion on
referenced and referencer columns resp.
3. The referencer table is distributed and referenced table is replicated
on all the nodes where the referencer table is distributed.

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.****
>
> ** **
>
>
> ------------------------------------------------------------------------------
> Android is increasing in popularity, but the open development platform that
> developers love is also attractive to malware creators. Download this white
> paper to learn more about secure code signing practices that can help keep
> Android apps secure.
> http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>


-- 
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company