summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2002-09-14 19:56:01 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2002-09-14 19:56:01 +0000
commitc0edc53a3693e2c7556457e4f9e05d68c7d1f739 (patch)
tree00d875cc8519122dbe6bc7324af4068b291dde2a
parentbd04184b110ecd02e2f24e13751e5bf131d51c5e (diff)
downloadpostgresql-c0edc53a3693e2c7556457e4f9e05d68c7d1f739.tar.gz
The attached adds GRANTs to PUBLIC for contrib/fuzzystringmatch.
Joe Conway
-rw-r--r--contrib/fuzzystrmatch/fuzzystrmatch.sql.in5
1 files changed, 5 insertions, 0 deletions
diff --git a/contrib/fuzzystrmatch/fuzzystrmatch.sql.in b/contrib/fuzzystrmatch/fuzzystrmatch.sql.in
index b02f1b28eb..0be715bac7 100644
--- a/contrib/fuzzystrmatch/fuzzystrmatch.sql.in
+++ b/contrib/fuzzystrmatch/fuzzystrmatch.sql.in
@@ -9,3 +9,8 @@ CREATE FUNCTION soundex(text) RETURNS text
CREATE FUNCTION text_soundex(text) RETURNS text
AS 'MODULE_PATHNAME', 'soundex' LANGUAGE 'c';
+
+GRANT EXECUTE ON FUNCTION levenshtein (text,text) TO PUBLIC;
+GRANT EXECUTE ON FUNCTION metaphone (text,int) TO PUBLIC;
+GRANT EXECUTE ON FUNCTION soundex(text) TO PUBLIC;
+GRANT EXECUTE ON FUNCTION text_soundex(text) TO PUBLIC;