Hi folks,
I am setting up an Arches v5 installation in a Vbox Virtual Machine on my
laptop using the install script for Ubuntu 18.04 using the install script
install_ubuntu.sh fetched from github.
I got as far as the line:
sudo -u postgres psql -d template_postgis -c "CREATE EXTENSION postgis;"
and got the following:
***STARTS***
WARNING: nonstandard use of escape in a string literal
LINE 5: SELECT substring(version(), 'PostgreSQL ([0-9\.]+)') INTO p...
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
QUERY:
DECLARE
pgver text;
BEGIN
SELECT substring(version(), 'PostgreSQL ([0-9\.]+)') INTO pgver;
IF 120::text != ( SELECT CASE
WHEN split_part(s,'.',1)::integer > 9
THEN split_part(s,'.',1) || '0'
ELSE
split_part(s,'.', 1) || split_part(s,'.', 2)
END
FROM substring(version(), 'PostgreSQL ([0-9\.]+)') AS s )
THEN
RAISE EXCEPTION 'PostGIS built for PostgreSQL % cannot be loaded in
PostgreSQL %',
12.0, pgver;
END IF;
END;
WARNING: nonstandard use of escape in a string literal
LINE 13: FROM substring(version(), 'PostgreSQL ([0-9\.]+)') AS s )
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
QUERY:
DECLARE
pgver text;
BEGIN
SELECT substring(version(), 'PostgreSQL ([0-9\.]+)') INTO pgver;
IF 120::text != ( SELECT CASE
WHEN split_part(s,'.',1)::integer > 9
THEN split_part(s,'.',1) || '0'
ELSE
split_part(s,'.', 1) || split_part(s,'.', 2)
END
FROM substring(version(), 'PostgreSQL ([0-9\.]+)') AS s )
THEN
RAISE EXCEPTION 'PostGIS built for PostgreSQL % cannot be loaded in
PostgreSQL %',
12.0, pgver;
END IF;
END;
WARNING: nonstandard use of escape in a string literal
LINE 1: SELECT substring(version(), 'PostgreSQL ([0-9\.]+)')
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
QUERY: SELECT substring(version(), 'PostgreSQL ([0-9\.]+)')
WARNING: nonstandard use of escape in a string literal
LINE 7: FROM substring(version(), 'PostgreSQL ([0-9\.]+)') AS s )
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
QUERY: SELECT 120::text != ( SELECT CASE
WHEN split_part(s,'.',1)::integer > 9
THEN split_part(s,'.',1) || '0'
ELSE
split_part(s,'.', 1) || split_part(s,'.', 2)
END
FROM substring(version(), 'PostgreSQL ([0-9\.]+)') AS s )
CREATE EXTENSION
***ENDS***
Can anyone help with what is going on here?
Ta,
Pat
--
-- To post, send email to [email protected]. To unsubscribe, send
email to [email protected]. For more information,
visit https://groups.google.com/d/forum/archesproject?hl=en
---
You received this message because you are subscribed to the Google Groups
"Arches Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/archesproject/3fc803c7-3310-4114-b48c-52e80f5a242cn%40googlegroups.com.
