[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