diff options
| author | Bruce Momjian <bruce@momjian.us> | 2013-10-08 12:20:36 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2013-10-08 12:20:36 -0400 |
| commit | 9299f6179838cef8aa1123f6fb76f0d3d6f2decc (patch) | |
| tree | 6833ce4c2aad28d7772ae1538cfcef34ab3139c0 | |
| parent | ee1e5662d8d8330726eaef7d3110cb7add24d058 (diff) | |
| download | postgresql-9299f6179838cef8aa1123f6fb76f0d3d6f2decc.tar.gz postgresql-9299f6179838cef8aa1123f6fb76f0d3d6f2decc.zip | |
unaccent: mark unaccent() functions as immutable
Suggestion from Pavel Stehule
| -rw-r--r-- | contrib/unaccent/unaccent--1.0.sql | 4 | ||||
| -rw-r--r-- | contrib/unaccent/unaccent--unpackaged--1.0.sql | 6 |
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; |