Postgres 15 needs QGEP datamodel adaptations to work about qgep HOT 3 OPEN

@ponceta Can you add that to the roadmap too?

from qgep.

PostgreSQL 15 is probably fine, postgis 3.3 and later are requiring some datamodel adaptations and postgis 3.2 is not shipped with PostgreSQL 15 anymore.

• [ ] #825

from qgep.

I restored and used qgep demo data 1.6.0 on postgres 15 and postgis 3.4 locally with no error message yet.

I was able to create some reaches using QGIS but same error happens when reach points altitudes are NULL (not 0) (rp_from, rp_to)

If run by pgAdmin :

INSERT INTO qgep_od.vw_qgep_reach (progression_geometry, rp_from_obj_id, rp_to_obj_id) VALUES (ST_SetSRID(ST_GeomFromText('COMPOUNDCURVE Z ((1 2 3,4 5 6,7 8 9))'), 2056), 'BBB 1337_0001', 'CCC 1337_0001' );

Will fail with following error message :

ERROR:  Geometry contains invalid coordinate
CONTEXT:  fonction PL/pgSQL qgep_od.ft_vw_qgep_reach_insert(), ligne 7 à affectation 

ERREUR:  Geometry contains invalid coordinate
État SQL : XX000

from qgep.