[midPoint-git] [Evolveum/midpoint] 5977a2: Added DB Schema for Postgres 16

[Tony Tkáčik]

  Branch: refs/heads/master
  Home:   https://github.com/Evolveum/midpoint
  Commit: 5977a2c39e74d624390295799abd97cacfb3ffa4
      https://github.com/Evolveum/midpoint/commit/5977a2c39e74d624390295799abd97cacfb3ffa4
  Author: Tony Tkáčik <tonydamage at gmail.com>
  Date:   2023-09-22 (Fri, 22 Sep 2023)

  Changed paths:
    M config/sql/native/postgres.sql

  Log Message:
  -----------
  Added DB Schema for Postgres 16

In Postgres 16 there was incompatible change regarding generated columns,
which we are using for objectType, referenceType and containerType

Previously to 16:
Parent column must be non-generated, if child columns have
   different generation expressions.

After 16:
Parent column must always be generated if child columns are generated.
But they may have different generation expressions.

In postgres.sql we need to detect Postgres version and add correct definitions
of objectType, referenceType and containerType using ALTER TABLE ADD COLUMN,
since required changes are not achievable using ALTER TABLE MODIFY COLUMN


  Commit: eb618752266860a403d2cc1b7891612affa77ea2
      https://github.com/Evolveum/midpoint/commit/eb618752266860a403d2cc1b7891612affa77ea2
  Author: Tony Tkáčik <tonydamage at gmail.com>
  Date:   2023-09-22 (Fri, 22 Sep 2023)

  Changed paths:
    M config/sql/native/postgres.sql

  Log Message:
  -----------
  Postgres 16: m_assignment no more inherits from m_container

Signed-off-by: Tony Tkáčik <tonydamage at gmail.com>


  Commit: 18cdd121815aaa1aa2f6ffc82608461d94180761
      https://github.com/Evolveum/midpoint/commit/18cdd121815aaa1aa2f6ffc82608461d94180761
  Author: Tony Tkáčik <tonydamage at gmail.com>
  Date:   2023-09-25 (Mon, 25 Sep 2023)

  Changed paths:
    M gui/admin-gui/src/frontend/js/midpoint-theme.js
    M gui/admin-gui/src/frontend/scss/midpoint-utils.scss
    M gui/admin-gui/src/frontend/scss/midpoint.scss
    M gui/admin-gui/src/main/java/com/evolveum/midpoint/gui/impl/page/admin/resource/component/wizard/objectType/activation/PredefinedMappingStepPanel.java
    M model/authentication-impl/src/main/java/com/evolveum/midpoint/authentication/impl/filter/saml/MidpointSaml2LogoutRequestResolver.java
    M model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/visualizer/ActivationDescriptionHandler.java
    M model/model-impl/src/test/resources/common/system-configuration.xml
    M model/model-intest/src/test/resources/common/system-configuration.xml
    M model/model-intest/src/test/resources/gensync/system-configuration.xml
    M model/model-intest/src/test/resources/scripthooks/system-configuration-hooks.xml
    M model/model-intest/src/test/resources/scripting/system-configuration.xml
    M model/model-intest/src/test/resources/simulation/system-configuration.xml
    M repo/system-init/src/main/java/com/evolveum/midpoint/init/StartupConfiguration.java
    M testing/story/src/test/resources/common/system-configuration.xml
    M tools/ninja/src/main/java/com/evolveum/midpoint/ninja/impl/NinjaContext.java

  Log Message:
  -----------
  Merge remote-tracking branch 'origin/master' into feature/postgres-16


  Commit: 13b1f1df89635f4425ea091087c232579199f63b
      https://github.com/Evolveum/midpoint/commit/13b1f1df89635f4425ea091087c232579199f63b
  Author: Tony Tkáčik <tonydamage at gmail.com>
  Date:   2023-09-25 (Mon, 25 Sep 2023)

  Changed paths:
    M repo/repo-sqale/src/test/java/com/evolveum/midpoint/repo/sqale/func/SqaleRepoAddDeleteObjectTest.java

  Log Message:
  -----------
  Use QAssignment in Sqale Repo tests when checking assignments.


  Commit: 169620b81d13cbb13921bac62bc580d0daf1a221
      https://github.com/Evolveum/midpoint/commit/169620b81d13cbb13921bac62bc580d0daf1a221
  Author: Tony Tkáčik <tonydamage at gmail.com>
  Date:   2023-09-25 (Mon, 25 Sep 2023)

  Changed paths:
    M config/sql/native/postgres-upgrade.sql
    M config/sql/native/postgres.sql
    M gui/admin-gui/src/main/java/com/evolveum/midpoint/gui/api/component/PendingOperationPanel.java
    M repo/repo-sqale/src/main/java/com/evolveum/midpoint/repo/sqale/SqaleUtils.java
    M repo/repo-sqale/src/main/java/com/evolveum/midpoint/repo/sqale/qmodel/connector/MConnector.java
    M repo/repo-sqale/src/main/java/com/evolveum/midpoint/repo/sqale/qmodel/connector/QConnector.java
    M repo/repo-sqale/src/main/java/com/evolveum/midpoint/repo/sqale/qmodel/connector/QConnectorMapping.java

  Log Message:
  -----------
  Merge remote-tracking branch 'origin/master' into feature/postgres-16


  Commit: ca0b0e0ed39b659b25afdaaa8194be8d81b7d33d
      https://github.com/Evolveum/midpoint/commit/ca0b0e0ed39b659b25afdaaa8194be8d81b7d33d
  Author: Tony Tkáčik <tonydamage at gmail.com>
  Date:   2023-09-26 (Tue, 26 Sep 2023)

  Changed paths:
    M config/sql/native/postgres.sql
    M repo/repo-sqale/src/test/java/com/evolveum/midpoint/repo/sqale/func/SqaleRepoAddDeleteObjectTest.java

  Log Message:
  -----------
  Merge branch 'feature/postgres-16'


Compare: https://github.com/Evolveum/midpoint/compare/28e473608d3f...ca0b0e0ed39b