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

Tony Tkáčik noreply at github.com
Fri Sep 22 11:36:34 CEST 2023


  Branch: refs/heads/feature/postgres-16
  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




More information about the midPoint-svn mailing list