postgres-upgrade.sql - midPoint 4.11

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

Changes

Change Description

Change 58

Adds display and preferred name columns and indexes to users.

Change 57

Recreates connector type/version uniqueness indexes with connector-host specific predicates.

Change 56

Drops old connector type/version uniqueness indexes before recreating them.

Change 55

Adds connector development object table and triggers.

Change 54

Adds CONNECTOR_DEVELOPMENT object type value.

Change 53

Adds application object table, triggers, and indexes.

Change 52

Adds APPLICATION object type value.

Change 58

Since version: 4.11

Adds display and preferred name columns and indexes to users.

Object Change type Description

m_user

Modified table

Adds display and preferred name columns.

m_user_displayNameOrig_idx

New index

Supports lookup by original display name.

m_user_preferredNameOrig_idx

New index

Supports lookup by original preferred name.

Change 57

Since version: 4.11

Recreates connector type/version uniqueness indexes with connector-host specific predicates.

Object Change type Description

m_connector_typeVersion_key

New index

Enforces connector type/version uniqueness when connector host is not set.

m_connector_typeVersionHost_key

New index

Enforces connector type/version/host uniqueness when connector host is set.

Change 56

Since version: 4.11

Drops old connector type/version uniqueness indexes before recreating them.

Object Change type Description

m_connector_typeVersion_key

Removed index

Drops old connector type/version uniqueness index.

m_connector_typeversionhost_key

Removed index

Drops old connector type/version/host uniqueness index.

Change 55

Since version: 4.11

Adds connector development object table and triggers.

Object Change type Description

m_connector_development

New table

Stores connector development objects.

m_connector_development_oid_insert_tr

New trigger

Reserves OID rows for inserted connector development objects.

m_connector_development_update_tr

New trigger

Maintains update metadata for connector development objects.

m_connector_development_oid_delete_tr

New trigger

Releases OID rows for deleted connector development objects.

Change 54

Since version: 4.11

Adds CONNECTOR_DEVELOPMENT object type value.

Object Change type Description

ObjectType

Modified enum type

Adds CONNECTOR_DEVELOPMENT.

Change 53

Since version: 4.11

Adds application object table, triggers, and indexes.

Object Change type Description

m_application

New table

Stores application objects.

m_application_oid_insert_tr

New trigger

Reserves OID rows for inserted applications.

m_application_update_tr

New trigger

Maintains update metadata for applications.

m_application_oid_delete_tr

New trigger

Releases OID rows for deleted applications.

m_application_nameOrig_idx

New index

Supports lookup by original object name.

m_application_nameNorm_key

New unique index

Enforces unique normalized object names.

m_application_subtypes_idx

New index

Supports filtering by subtype.

m_application_identifier_idx

New index

Supports lookup by identifier.

m_application_validFrom_idx

New index

Supports filtering by validity start.

m_application_validTo_idx

New index

Supports filtering by validity end.

m_application_fullTextInfo_idx

New index

Supports full-text-like searches.

m_application_createTimestamp_idx

New index

Supports filtering or ordering by creation time.

m_application_modifyTimestamp_idx

New index

Supports filtering or ordering by modification time.

Change 52

Since version: 4.11

Adds APPLICATION object type value.

Object Change type Description

ObjectType

Modified enum type

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