On Thu, Jun 27, 2019 at 12:46:03PM +0200, olivier.lo...@umontpellier.fr wrote:
> at line 248, substring(upgraded from '[0-9]*\.([0-9]*)\.’) cannot be cast to > int since it leads ‘’ because of the « SELECT '2.2'::text as upgraded » at > line 242. > > replacing SELECT '2.2'::text as upgraded with SELECT ‘2.2.2'::text as > upgraded solves the issue > > Looks like there is the same problem with any migration scripts from 2.1.xx > > Maybe a problem of compilation/debian distribution (since I installed postgis > using debian packages) ? I guess we could just pick the first two numbers and drop the final '\.' portion of the regexp... What surprises me is that our CI bots testing upgrades did not catch this issue. Maybe it is only coming from your old 2.1.xx version rather than the versions tested by CI (2.1.9) ? Also, you didn't show the output of: SELECT Postgis_full_version() --strk; _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
