Uploaded image for project: 'COmanage'
  1. COmanage
  2. CO-2548

COmanage Match PostgreSQL version requirement

    XMLWordPrintable

Details

    Description

      Building a Matchgrid fails with the following error when using PostgreSQL version < 9.5

      error: [Doctrine\DBAL\Exception\SyntaxErrorException] An exception occurred while executing a query: SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "NOT"
      LINE 1: CREATE INDEX IF NOT EXISTS matchgrid_1_attr_id3 ON mg_zzzz (L...
                              ^ in /srv/comanage/match-1.0.0/app/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php on line 66
      Caused by: [Doctrine\DBAL\Driver\PDO\Exception] SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "NOT"
      LINE 1: CREATE INDEX IF NOT EXISTS matchgrid_1_attr_id3 ON mg_zzzz (L...
                              ^ in /srv/comanage/match-1.0.0/app/vendor/doctrine/dbal/src/Driver/PDO/Exception.php on line 30
      Caused by: [PDOException] SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "NOT"
      LINE 1: CREATE INDEX IF NOT EXISTS matchgrid_1_attr_id3 ON mg_zzzz (L...
                              ^ in /srv/comanage/match-1.0.0/app/vendor/doctrine/dbal/src/Driver/PDO/Connection.php on line 72
      Request URL: /matchgrids/build/1

       

      "CREATE INDEX IF NOT EXISTS" was not introduced until PostgreSQL version 9.5.

      The [COmanage Match Installation - Database|https://spaces.at.internet2.edu/display/COmanage/Match+Installation+-+Database] wiki page lists 9.1 as the minimum version.  Perhaps it should be updated to list 9.5?

      Attachments

        Activity

          People

            benn.oshrin@at.internet2.edu Benn Oshrin (internet2.edu)
            s.s@at.internet2.edu Seth Stein
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: