[postgis-users] fail to upgrade from 2.1.8 to 2.2.2 or 2.3.3

olivier.lobry at umontpellier.fr olivier.lobry at umontpellier.fr
Wed Jun 26 02:20:59 PDT 2019


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'.
WARNING:  nonstandard use of escape in a string literal
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING:  nonstandard use of escape in a string literal
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING:  nonstandard use of escape in a string literal
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING:  nonstandard use of escape in a string literal
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING:  nonstandard use of escape in a string literal
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING:  nonstandard use of escape in a string literal
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
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 ?

How can I get more debug information ?

Is it possible to execute the command step-by-step to see where the underlying script fails ?


Best regards

Olivier








More information about the postgis-users mailing list