Details
-
Fix
-
Status: Released (View Workflow)
-
Major
-
Resolution: Fixed
-
1.10
-
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
Issue Links
- is related to
-
SET-20 Setup should create the sequence "SCHEDULER_MON_CHECKS_ID_SEQ" only if it doesn't exist
- Approved