Skip to content

Postgres Compatibility Pre 9.6

Kevin Kelly edited this page Aug 13, 2018 · 3 revisions

The following is a list of items that require attention to make ClassDB compatible with Postgres versions prior to 9.6.

Please add every item discovered to this table so we get a full picture before creating and addressing them as issues.

Do not create issues for these items until after Milestone M3 is complete and we have had a chance to review these items.

Reference: Postgres feature matrix

Item Description pg version changed in Source file(s)
GRANT Syntax changed 9.5 initializeDBCore.sql
pg_signal_backend Role added 9.6 initalizeServerCore.sql, addConnectionMgmtReco.sql
ALTER SYSTEM Statement added 9.4 enableConnectionLoggingReco.psql, disableConnectionLoggingReco.psql
IF NOT EXISTS Option added to CREATE INDEX 9.5 addRoleBaseMgmtCore.sql
pg_event_trigger_ddl_commands Function added 9.5 addDDLActivtiyLoggingReco.sql
IF NOT EXISTS Option added to ADD COLUMN 9.6 addUserMgmtCore.sql

Clone this wiki locally