[postgis-tickets] [PostGIS] #5033: Breaking change in PostGIS 3.1 with introduction of gridSize
PostGIS
trac at osgeo.org
Thu Dec 16 10:18:47 PST 2021
#5033: Breaking change in PostGIS 3.1 with introduction of gridSize
----------------------+---------------------------
Reporter: robe | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 3.1.5
Component: postgis | Version: 3.1.x
Resolution: | Keywords:
----------------------+---------------------------
Comment (by strk):
There's still a pending issue: renamed functions (not drop) are left
pointing to possibly unexisting library:
{{{
# regress/run_test.pl --before-upgrade-script regress/hooks/hook-before-
upgrade.sql --extension --upgrade-path ${F}--3.2.0dev!
regress/core/regress -v --nodrop
Creating database 'postgis_reg'
Preparing db 'postgis_reg' using: CREATE EXTENSION postgis VERSION
'2.5.6dev' SCHEMA public
Upgrading from postgis 2.5.6dev
Running before-upgrade-script regress/hooks/hook-before-upgrade.sql
WARNING: postgis_extensions_upgrade() not available or functional in
version 2.5.6dev. We'll use manual upgrade.
Upgrading PostGIS in 'postgis_reg' using: ALTER EXTENSION postgis UPDATE
TO '3.2.0dev'
Packaging PostGIS Raster in 'postgis_reg' for later drop using: ALTER
EXTENSION postgis UPDATE TO '3.2.0dev'
Dropping PostGIS Raster in 'postgis_reg' using: CREATE EXTENSION
postgis_raster VERSION '3.2.0dev' FROM unpackaged;
PostgreSQL 12.7 (Ubuntu 12.7-0ubuntu0.20.10.1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 10.2.0-13ubuntu1) 10.2.0, 64-bit
Postgis 3.2.0dev - (3.2.0rc1-11-g211893b3a) - 2021-10-18 22:13:19
scripts 3.2.0dev 3.2.0rc1-11-g211893b3a
GEOS: 3.11.0dev-CAPI-1.16.0
PROJ: 7.1.0
Running tests
regress/core/regress .. failed (diff expected obtained:
/tmp/pgis_reg/test_1_diff)
-----------------------------------------------------------------------------
--- regress/core/regress_expected 2021-07-01 12:48:31.374498018
+0200
+++ /tmp/pgis_reg/test_1_out 2021-12-16 19:16:10.970197463 +0100
@@ -231,3 +231,8 @@
314|676
315|0
316|t|LINESTRING(40 8.660254037844387,35 8.660254037844387)
+unexpected
probin|st_difference_deprecated_by_postgis_301:$libdir/postgis-2.5
+unexpected
probin|st_intersection_deprecated_by_postgis_301:$libdir/postgis-2.5
+unexpected
probin|st_subdivide_deprecated_by_postgis_301:$libdir/postgis-2.5
+unexpected
probin|st_symdifference_deprecated_by_postgis_301:$libdir/postgis-2.5
+unexpected
probin|st_unaryunion_deprecated_by_postgis_301:$libdir/postgis-2.5
-----------------------------------------------------------------------------
}}}
This may be a problem in production as the users's views might be just
disfunctioning unless the old ones point to the same major version as the
new ones (and we didn't change function name in the library).
For the testcase it could be only fixed by adapting those views (either
automatically or by the test itself, maybe upgrading against after having
dropped the views)
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5033#comment:9>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list