Opened 5 years ago

Closed 5 years ago

#3737 closed defect (invalid)

Upgrading from 2.2.5 to 2.3.2 problem

Reported by: zeddi Owned by: robe
Priority: medium Milestone: PostGIS 2.3.3
Component: build/upgrade/install Version: 2.3.x
Keywords: Cc: robe

Description

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.

Change History (9)

comment:1 by strk, 5 years ago

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

comment:3 by strk, 5 years ago

What PostgreSQL version is that ?

comment:4 by strk, 5 years ago

Cc: robe added

comment:5 by zeddi, 5 years ago

9.6.2

comment:6 by strk, 5 years ago

Owner: changed from strk to robe

comment:7 by robe, 5 years ago

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.

comment:8 by zeddi, 5 years ago

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

comment:9 by robe, 5 years ago

Resolution: invalid
Status: newclosed
Note: See TracTickets for help on using tickets.