From 03c373a4b3e031ab977c5bffb9f09731b28581a6 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Wed, 26 Feb 2020 11:41:49 +0100 Subject: [PATCH] make all query partition functions stable --- sql/partition-functions.src.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/sql/partition-functions.src.sql b/sql/partition-functions.src.sql index 07e99c97..8f78032e 100644 --- a/sql/partition-functions.src.sql +++ b/sql/partition-functions.src.sql @@ -39,7 +39,7 @@ BEGIN RAISE EXCEPTION 'Unknown partition %', in_partition; END $$ -LANGUAGE plpgsql; +LANGUAGE plpgsql STABLE; create or replace function deleteLocationArea(in_partition INTEGER, in_place_id BIGINT, in_rank_search INTEGER) RETURNS BOOLEAN AS $$ DECLARE @@ -145,7 +145,7 @@ BEGIN RAISE EXCEPTION 'Unknown partition %', in_partition; END $$ -LANGUAGE plpgsql; +LANGUAGE plpgsql STABLE; create or replace function insertSearchName( @@ -254,7 +254,7 @@ BEGIN RAISE EXCEPTION 'Unknown partition %', in_partition; END $$ -LANGUAGE plpgsql IMMUTABLE; +LANGUAGE plpgsql STABLE; CREATE OR REPLACE FUNCTION getNearestParallelRoadFeature(in_partition INTEGER, line GEOMETRY) @@ -298,4 +298,4 @@ BEGIN RAISE EXCEPTION 'Unknown partition %', in_partition; END $$ -LANGUAGE plpgsql IMMUTABLE; +LANGUAGE plpgsql STABLE; -- 2.39.5