[CalendarServer-dev] 9.1 needs PostgreSQL 9.5+

[Axel Rau]

While upgrading from 9.0 to 9.1, I’m getting:

	  File "/usr/local/lib/python2.7/site-packages/twext/enterprise/adbapi2.py", line 246, in _reallyExecSQL
	    self._cursor.execute(sql, args)
	  File "/usr/local/lib/python2.7/site-packages/txdav/base/datastore/dbapiclient.py", line 82, in execute
	    self.realCursor.execute(sql, args)
	  File "/usr/local/lib/python2.7/site-packages/pg8000/core.py", line 906, in execute
	    self._c.execute(self, operation, args)
	  File "/usr/local/lib/python2.7/site-packages/pg8000/core.py", line 1940, in execute
	    self.handle_messages(cursor)
	  File "/usr/local/lib/python2.7/site-packages/pg8000/core.py", line 2088, in handle_messages
	    raise self.error
	pg8000.core.ProgrammingError: (u’ERROR', u'42601', u'syntax error at or near "skip"', u'205', u'scan.l', u'1053', u'scanner_yyerror', u'', u'')

PostgreSQL 9.4 server log shows:

"syntax error at or near ""skip""",,,,,,"select JOB_ID, WORK_TYPE, PRIORITY,
WEIGHT, NOT_BEFORE, IS_ASSIGNED, ASSIGNED, OVERDUE, FAILED, PAUSE from JOB
where IS_ASSIGNED = $1 and PAUSE = $2 and NOT_BEFORE <= $3 order by PRIORITY
desc for update skip locked limit $4“,205,,“"

Axel
---
PGP-Key:29E99DD6  ☀  computing @ chaos claudius