postgres-upgrade.sql - midPoint 4.7

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

Changes

Change Description

Change 15

Adds queryable abstract flag to resources.

Change 14

Renames approval reference indexes to use consistent naming.

Change 13

Adds simulation result, processed object, mark, and effective mark tables, triggers, functions, and indexes.

Change 12

Adds simulation, mark, and related reference/container enum values.

Change 15

Since version: 4.7

Adds queryable abstract flag to resources.

Object Change type Description

m_resource

Modified table

Adds queryable abstract flag.

Change 14

Since version: 4.7

Renames approval reference indexes to use consistent naming.

Object Change type Description

m_ref_object_create_approverTargetOidRelationId_idx

Renamed index

Renames create-approver reference index to consistent naming.

m_ref_object_modify_approverTargetOidRelationId_idx

Renamed index

Renames modify-approver reference index to consistent naming.

Change 13

Since version: 4.7

Adds simulation result, processed object, mark, and effective mark tables, triggers, functions, and indexes.

Object Change type Description

m_simulation_result

New table

Stores simulation result objects.

m_simulation_result_oid_insert_tr

New trigger

Reserves OID rows for inserted simulation results.

m_simulation_result_update_tr

New trigger

Maintains update metadata for simulation results.

m_simulation_result_oid_delete_tr

New trigger

Releases OID rows for deleted simulation results.

ObjectProcessingStateType

New enum type

Stores processed object states for simulation results.

m_simulation_result_processed_object

New table

Stores processed objects belonging to simulation results.

m_simulation_result_processed_object_default

New partition

Default partition for processed simulation objects.

m_simulation_result_create_partition

New function

Creates processed-object partitions for partitioned simulation results.

m_simulation_result_create_partition

New trigger

Creates processed-object partition when a partitioned simulation result is inserted.

m_simulation_result_delete_partition

New function

Drops processed-object partitions when a simulation result is deleted.

m_simulation_result_delete_partition

New trigger

Deletes processed-object partition before deleting a simulation result.

m_processed_object_event_mark

New table

Stores event mark references for processed simulation objects.

m_processed_object_event_mark_default

New partition

Default partition for processed-object event mark references.

m_mark

New table

Stores mark objects.

m_ref_object_effective_mark

New table

Stores effective mark references for objects.

m_ref_object_effective_mark_targetOidRelationId_idx

New index

Supports reverse lookup of effective mark references.

Change 12

Since version: 4.7

Adds simulation, mark, and related reference/container enum values.

Object Change type Description

ObjectType

Modified enum type

Adds MARK and SIMULATION_RESULT.

ReferenceType

Modified enum type

Adds processed-object event mark and object effective mark reference values.

ContainerType

Modified enum type

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