Opened 7 years ago

Closed 7 years ago

#4389 closed defect (fixed)

decode_url_part is only compatible with postgresql >= 9.0

Reported by: Loki Owned by: geocoding@…
Priority: major Milestone:
Component: nominatim Version: 2.0
Keywords: Cc:


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.

Change History (1)

comment:1 Changed 7 years ago by Sarah Hoffmann

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