Opened 8 months ago

Closed 3 months ago

Last modified 3 months ago

#5700 closed defect (fixed)

error when upgrading postgis_sfcgal

Reported by: robe Owned by: lbartoletti
Priority: blocker Milestone: PostGIS 3.5.0
Component: sfcgal Version: master
Keywords: Cc:

Description

Just tried to upgrade my postgis_sfcgal on demo.postgis.net and getting this error:

SELECT postgis_extensions_upgrade();
HINT:  Use DROP FUNCTION st_3dintersection(geometry,geometry) first.
CONTEXT:  SQL statement "ALTER EXTENSION postgis_sfcgal UPDATE TO "ANY";ALTER EXTENSION postgis_sfcgal UPDATE TO "3.5.0dev""

Why do we need to drop st_3dintersection?

or is this just some weird thing cause I have this instance in constant build mode.

Change History (3)

comment:1 by Sandro Santilli <strk@…>, 3 months ago

Resolution: fixed
Status: newclosed

In 49883c5/git:

Restore 3.4 signature for deprecated ST_3DIntersect SFCGAL function

Closes #5700

comment:2 by strk, 3 months ago

This ticket reveals that Woodie (which is testing all upgrades) is failing to test the SFCGAL extension upgrades. Indeed the check_all_upgrades.sh script reports sfcgal extension is not installed, for some reason: https://woodie.osgeo.org/repos/30/pipeline/2427/21#L7480

I filed #5773 to fix this

comment:3 by Sandro Santilli <strk@…>, 3 months ago

In 254ae99/git:

Restore 3.4 signature for deprecated sfcgal 3d functions

References #5700, #5773

Note: See TracTickets for help on using tickets.