Uploaded image for project: 'Bitrepository'
  1. Bitrepository
  2. BITMAG-1114

Integrity service database migration fails

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 1.7.0.1
    • 1.7
    • Integrity
    • None

    Description

      [avisbits@bitmag-devel01 postgres]$ psql -d integritydb -f integrityDB6to7migration.sql
      UPDATE 1
      UPDATE 1
      UPDATE 1
      UPDATE 1
      UPDATE 1
      ALTER TABLE
      ALTER TABLE
      ALTER TABLE
      ALTER TABLE
      DROP INDEX
      UPDATE 97461
      UPDATE 97461
      UPDATE 97461
      UPDATE 97461
      ALTER TABLE
      ALTER TABLE
      ALTER TABLE
      ALTER TABLE
      ALTER TABLE
      ALTER TABLE
      ALTER TABLE
      ALTER TABLE
      ALTER TABLE
      ALTER TABLE
      psql:integrityDB6to7migration.sql:103: ERROR: syntax error at or near ";"
      LINE 1: ...p AT TIME ZONE (SELECT current_setting('TIMEZONE')) * 1000);
      ^

      Attachments

        Activity

          People

            Unassigned Unassigned
            ktc Kim Christensen (Inactive)
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: