Uploaded image for project: 'SET - Setups'
  1. SET - Setups
  2. SET-36

Setup should not raise error for existing relation "reporting_if_id_seq"

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.10
    • 1.10.1, 1.11
    • None

    Description

      During the update of release 1.10.0-RC1 to 1.10.0 for a PostgreSQL database the installer reports the following error: "Relation »reporting_if_id_seq« existiert bereits". More details are provided with the attached log.

      This problem seems to be related to the sequence specified in the attached sql script inventory.sql. The script tries to check if the sequence exists and otherwise would create it. In fact the check for existence of the sequence fails and subsequently the script runs into an error when re-createing the sequence.

      This might be related to the statement:

      SELECT COUNT(*) INTO c FROM pg_class,pg_namespace WHERE UPPER(pg_class.relname) = 'REPORTING_IF_ID_SEQ' AND pg_namespace.oid = pg_class.relnamespace AND pg_namespace.nspname = current_user
      

      This statement should identify an existing sequence and return the value 1 accordingly

      Attachments

        1. Install_V1.10.0_20150916010601_6245219176809913063.log
          16 kB
          Andreas Püschel
        2. inventory.sql
          10 kB
          Andreas Püschel

        Issue Links

          Activity

            People

              oh Oliver Haufe
              ap Andreas Püschel
              Santiago Aucejo Petzoldt Santiago Aucejo Petzoldt
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: