Menu

#36 Global constraints

Development Queue
open
nobody
5
2012-06-03
2012-04-23
No

Postgres-XC has now some limitations with constraints.
A constraint on a column or an inheritance can only be created if the constraint can be safely checked on remote node, for example:
- child and parent relations need to have similar distribution column types for REFERENCES or the parent needs to be a replicated table.

XC needs an additional mechanism to be able to fetch on Coordinator a tuple based on ctid and xc_node_id to be able to check constraint on Coordinator. Those kind of mechanisms are also used by triggers.

Discussion

  • Michael Paquier

    Michael Paquier - 2012-04-23
    • assigned_to: mason_s --> nobody
    • summary: Global constrints --> Global constraints
     
  • Koichi Suzuki

    Koichi Suzuki - 2012-06-03
    • milestone: --> Development Queue
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.