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

Allow use of auto-generated integers for VCS doc ids on PostgreSQL

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.7.1
    • Component/s: Core VCS
    • Tags:
    • Impact type:
      Configuration Change
    • Upgrade notes:
      Hide

      To activate, in the repository config, add:

      <idType>sequence</idType>

      Or if you want to use another sequence than the default (hierarchy_seq), use:

      <idType>sequence:your_sequence_name</idType>

      Show
      To activate, in the repository config, add: <idType>sequence</idType> Or if you want to use another sequence than the default (hierarchy_seq), use: <idType>sequence:your_sequence_name</idType>

      Description

      Following NXP-4803 where we allow the use of native uuids for document ids in the database, we could also allow using int8 from a SEQUENCE to further improve performance.

      For PostgreSQL for now.

        Attachments

          Issue Links

          depends on

          Improvement - An improvement or enhancement to an existing feature or task. NXP-4803 VCS with PostgreSQL should use UUID type for doc id field

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is required by

          New Feature - A new feature of the product, which has yet to be developed. NXP-13800 VCS: auto-generated integer ids on Oracle

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. NXP-10912 Allow use of auto-generated integers for VCS doc ids on MS SQL Server

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: