Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-22724

Database-level integrity constraints on simple lists for PostgreSQL

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 9.3
    • Component/s: Core VCS
    • Release Notes Description:
      Hide

      When using Postgres, a UNIQUE INDEX has been added on several tables preventing from having twice the same entry: the list of contributors, as well as the hierarchy tables.

      Show
      When using Postgres, a UNIQUE INDEX has been added on several tables preventing from having twice the same entry: the list of contributors, as well as the hierarchy tables.
    • Backlog priority:
      600
    • Sprint:
      nxcore 9.3.5, nxcore 9.3.7
    • Story Points:
      3

      Description

      Following NXP-22421 that added database-level integrity constraints for unique names of children in their parents (and similarly for complex properties), we also want to add uniqueness constraints to list elements to avoid incorrect concurrent additions.

      The idea would be to automatically add unique indexes such as:

      CREATE UNIQUE INDEX ON dc_contributors (id, pos);
      

      on all tables corresponding to lists.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 4 hours
                  4h