#4389: decode_url_part is only compatible with postgresql >= 9.0
-----------------------+----------------------------------------------------
Reporter: lokkju | Owner: geocoding@…
Type: defect | Status: new
Priority: major | Milestone:
Component: nominatim | Version: 2.0
Keywords: |
-----------------------+----------------------------------------------------
The decode_url_part function in functions.sql is only compatible with
version of postgresql >= 9.0 due to the use of the 'string_agg' function.
An alternative implementation of decode_url_part function that is
compatible with postgresql 8.4 is provided on the same stackoverflow page
that provided the 9.0+ implementation. I would suggest either just using
the 8.4 compatible version, or else conditionally using one or the other
based on the postgresql version.
--
Ticket URL: <https://trac.openstreetmap.org/ticket/4389>
OpenStreetMap <http://www.openstreetmap.org/>
OpenStreetMap is a free editable map of the whole world
_______________________________________________
Geocoding mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/geocoding
