Upgrading from 2.2.5 to 2.3.2 problem

[zeddi]

While doing: ALTER EXTENSION postgis UPDATE TO "2.3.2"; I get: ERROR: syntax error at or near "." LINE 1: SELECT @extschema@._postgis_deprecate('ST_Shift_Longitude',…

QUERY: SELECT @extschema@._postgis_deprecate('ST_Shift_Longitude', 'ST_ShiftLongitude', '2.2.0');

SELECT @extschema@.ST_ShiftLongitude($1);

Postgis version: POSTGIS="2.2.5 r15298" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 2.1.3, released 2017/20/01" LIBXML="2.9.1" TOPOLOGY

Postgis is compiled from source.

[strk]

What SVN revision did you build from source ? The @extschema@ should not be in the upgrade file, I think

[zeddi]

I compiled 2.3.2 version from: ​http://download.osgeo.org/postgis/source/postgis-2.3.2.tar.gz

[strk]

What PostgreSQL version is that ?

[zeddi]

9.6.2

[robe]

I suspect your postgis.control file might be the old one from PostGIS 2.2 and didn't get the 2.3 installed. In PostGIS 2.3 the schema is no longer relocatable. When not relocateable the @extchema@ gets macroreplaced by the extension machinery to the schema choosen by the user.

Your postgis.control should have:

relocatable = false

otherwise the extension system will not resolve the @extschema@ variables.

[zeddi]

Thanks, changing to "relocatable = false" solved the problem