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

PostgreSQL nx_init_ancestors fails when invoked twice

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.4.2
    • Fix Version/s: 5.5
    • Component/s: Core VCS
    • Environment:
      PostgreSQL

      Description

      There is a typo in the function that prevent to run it twice

      ERROR: trigger "nx_trig_ancestos_update" for relation "hierarchy" already exists
État SQL :42710
Contexte : SQL function "nx_ancestors_create_triggers" statement 6
SQL statement "SELECT  nx_ancestors_create_triggers()"
PL/pgSQL function "nx_init_ancestors" line 6 at PERFORM

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: