postgres-upgrade.sql - midPoint 4.8

Last modified 01 Jul 2026 12:22 UTC
Table of Contents

Changes

Change Description

Change 25

Updates organization closure refresh procedure to use advisory locking.

Change 24

Adds connector display name columns.

Change 23

Adds role analysis cluster and role analysis session tables, triggers, and indexes.

Change 22

Adds ROLE_ANALYSIS_CLUSTER and ROLE_ANALYSIS_SESSION object type values.

Change 21

Adds personal number column to users.

Change 20

Adds execution mode and predefined configuration enum types and task affected object columns.

Change 19

Recreates task affected object indexing table.

Change 18

Adds resource super-reference columns.

Change 17

Keeps change number reserved for replaced task affected object indexing change.

Change 16

Adds AFFECTED_OBJECTS container type value for task affected object indexing.

Change 25

Since version: 4.8

Updates organization closure refresh procedure to use advisory locking.

Object Change type Description

m_refresh_org_closure

Modified procedure

Uses advisory locking while refreshing organization closure data.

Change 24

Since version: 4.8

Adds connector display name columns.

Object Change type Description

m_connector

Modified table

Adds original and normalized display name columns.

Change 23

Since version: 4.8

Adds role analysis cluster and role analysis session tables, triggers, and indexes.

Object Change type Description

m_role_analysis_cluster

New table

Stores role analysis cluster objects.

m_role_analysis_cluster_oid_insert_tr

New trigger

Reserves OID rows for inserted role analysis clusters.

m_role_analysis_cluster_update_tr

New trigger

Maintains update metadata for role analysis clusters.

m_role_analysis_cluster_oid_delete_tr

New trigger

Releases OID rows for deleted role analysis clusters.

m_role_analysis_cluster_parentRefTargetOid_idx

New index

Supports lookup by parent reference target OID.

m_role_analysis_cluster_parentRefTargetType_idx

New index

Supports lookup by parent reference target type.

m_role_analysis_cluster_parentRefRelationId_idx

New index

Supports lookup by parent reference relation.

m_role_analysis_session

New table

Stores role analysis session objects.

m_role_analysis_session_oid_insert_tr

New trigger

Reserves OID rows for inserted role analysis sessions.

m_role_analysis_session_update_tr

New trigger

Maintains update metadata for role analysis sessions.

m_role_analysis_session_oid_delete_tr

New trigger

Releases OID rows for deleted role analysis sessions.

Change 22

Since version: 4.8

Adds ROLE_ANALYSIS_CLUSTER and ROLE_ANALYSIS_SESSION object type values.

Object Change type Description

ObjectType

Modified enum type

Adds ROLE_ANALYSIS_CLUSTER and ROLE_ANALYSIS_SESSION.

Change 21

Since version: 4.8

Adds personal number column to users.

Object Change type Description

m_user

Modified table

Adds personal number column.

Change 20

Since version: 4.8

Adds execution mode and predefined configuration enum types and task affected object columns.

Object Change type Description

ExecutionModeType

New enum type

Adds task execution mode values.

PredefinedConfigurationType

New enum type

Adds predefined configuration values.

m_task_affected_objects

Modified table

Adds execution mode and predefined configuration columns.

Change 19

Since version: 4.8

Recreates task affected object indexing table.

Object Change type Description

m_task_affected_resource_objects

Removed table

Drops obsolete development-time table if present.

m_task_affected_objects

Recreated table

Stores affected object data for tasks.

Change 18

Since version: 4.8

Adds resource super-reference columns.

Object Change type Description

m_resource

Modified table

Adds resource super-reference columns.

Change 17

Since version: 4.8

Keeps change number reserved for replaced task affected object indexing change.

Object Change type Description

change number

Reserved change

Keeps this change number reserved because the original table change was replaced by a later change.

Change 16

Since version: 4.8

Adds AFFECTED_OBJECTS container type value for task affected object indexing.

Object Change type Description

ContainerType

Modified enum type

Adds AFFECTED_OBJECTS.
Was this page helpful?
YES NO
Thanks for your feedback