aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2013-10-08 12:20:36 -0400
committerBruce Momjian <bruce@momjian.us>2013-10-08 12:20:36 -0400
commit9299f6179838cef8aa1123f6fb76f0d3d6f2decc (patch)
tree6833ce4c2aad28d7772ae1538cfcef34ab3139c0
parentee1e5662d8d8330726eaef7d3110cb7add24d058 (diff)
downloadpostgresql-9299f6179838cef8aa1123f6fb76f0d3d6f2decc.tar.gz
postgresql-9299f6179838cef8aa1123f6fb76f0d3d6f2decc.zip
unaccent: mark unaccent() functions as immutable
Suggestion from Pavel Stehule
-rw-r--r--contrib/unaccent/unaccent--1.0.sql4
-rw-r--r--contrib/unaccent/unaccent--unpackaged--1.0.sql6
2 files changed, 5 insertions, 5 deletions
diff --git a/contrib/unaccent/unaccent--1.0.sql b/contrib/unaccent/unaccent--1.0.sql
index 9085ca473fb..072b749e4b9 100644
--- a/contrib/unaccent/unaccent--1.0.sql
+++ b/contrib/unaccent/unaccent--1.0.sql
@@ -6,12 +6,12 @@
CREATE FUNCTION unaccent(regdictionary, text)
RETURNS text
AS 'MODULE_PATHNAME', 'unaccent_dict'
- LANGUAGE C STABLE STRICT;
+ LANGUAGE C IMMUTABLE STRICT;
CREATE FUNCTION unaccent(text)
RETURNS text
AS 'MODULE_PATHNAME', 'unaccent_dict'
- LANGUAGE C STABLE STRICT;
+ LANGUAGE C IMMUTABLE STRICT;
CREATE FUNCTION unaccent_init(internal)
RETURNS internal
diff --git a/contrib/unaccent/unaccent--unpackaged--1.0.sql b/contrib/unaccent/unaccent--unpackaged--1.0.sql
index abd06983ac4..5bff74ed6dc 100644
--- a/contrib/unaccent/unaccent--unpackaged--1.0.sql
+++ b/contrib/unaccent/unaccent--unpackaged--1.0.sql
@@ -10,7 +10,7 @@ ALTER EXTENSION unaccent ADD function unaccent_lexize(internal,internal,internal
ALTER EXTENSION unaccent ADD text search template unaccent;
ALTER EXTENSION unaccent ADD text search dictionary unaccent;
--- These functions are marked as stable in 9.1, were not before:
+-- These functions were marked as stable in 9.1; they were now marked as immutable
-ALTER FUNCTION unaccent(regdictionary, text) STABLE;
-ALTER FUNCTION unaccent(text) STABLE;
+ALTER FUNCTION unaccent(regdictionary, text) IMMUTABLE;
+ALTER FUNCTION unaccent(text) IMMUTABLE;