Merge remote-tracking branch 'upstream/master'

[nominatim.git] / lib-sql / functions / address_lookup.sql

diff --git a/lib-sql/functions/address_lookup.sql b/lib-sql/functions/address_lookup.sql
index cba11dbf3400d7fcc45a74f9c7fb85ed1a2f4c69..b59b7656bca93ddd3c8d88e819a93ca57fed1396 100644 (file)
--- a/lib-sql/functions/address_lookup.sql
+++ b/lib-sql/functions/address_lookup.sql
@@ -47,7 +47,7 @@ BEGIN
   RETURN trim((avals(name))[array_length(avals(name), 1)]);
 END;
 $$
-LANGUAGE plpgsql IMMUTABLE;
+LANGUAGE plpgsql IMMUTABLE PARALLEL SAFE;
 
 
 --housenumber only needed for tiger data
@@ -84,7 +84,7 @@ BEGIN
   RETURN array_to_string(result,', ');
 END;
 $$
-LANGUAGE plpgsql STABLE;
+LANGUAGE plpgsql STABLE PARALLEL SAFE;
 
 DROP TYPE IF EXISTS addressdata_place;
 CREATE TYPE addressdata_place AS (
@@ -331,4 +331,4 @@ BEGIN
   RETURN;
 END;
 $$
-LANGUAGE plpgsql STABLE;
+LANGUAGE plpgsql STABLE PARALLEL SAFE;