On Wed, Jun 26, 2019 at 11:20:59AM +0200, [email protected] wrote: > Hi, > > On a postgresql 9.3 / postgis 2.1.8 / debian 8.11, I cannot upgrade postgis > to 2.2.2 (or 2.3.3) :
> > # ALTER EXTENSION postgis UPDATE TO '2.2.2'; > WARNING: nonstandard use of escape in a string literal > HINT: Use the escape string syntax for escapes, e.g., E'\r\n'. [...] > ERROR: invalid input syntax for integer: « » > > Any idea of what happens ? Note that latest PostGIS version in the 2.2 branch is 2.2.8 (released on 2018/11/21) and latest in the 2.3 branch is 2.3.8 (released on 2019/03/11). Also, latest stable is 2.5.2 (released on 2019/03/11) Before moving on, I'd try *those* upgrades. > How can I get more debug information ? > Is it possible to execute the command step-by-step to see where the > underlying script fails ? Not with the "EXTENSION" mechanism, but you could try the script-way, using psql -f which would give you a line number of the failing statement. Please show the output of `SELECT postgis_full_version()" issued on your 2.1.8 install, and beware that a newer release in the 2.1 branch of PostGIS is also available: PostGIS 2.1.9 (2017/09/19) --strk; _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
