Hi Ashutosh, (2018/03/08 14:24), Ashutosh Bapat wrote:
Etsuro said [2] that WCO constraints can not be implemented on foreign server and normal check constraints can be, and for that he provides an example in [3]. But I think that example is going the wrong direction.
More precisely, what I'm saying there is: for WCO constraints created by an auto-updatable view over a foreign table, we cannot always implement constraints on the remote side that match with those WCO constraints.
For local constraints to be enforced, we use remote constraints. For local WCO we need to use remote WCO. That means we create many foreign tables pointing to same local table on the foreign server through many views, but it's not impossible.
Maybe I don't understand this correctly, but I guess that it would be the user's responsibility to not create foreign tables in such a way.
Best regards, Etsuro Fujita