Details
-
Documentation
-
Resolution: Fixed
-
Minor
-
COmanage Match 1.0.0 (Suitable Pear)
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?