From bec3df839c48bb359a00b68605ddc28400d02f5e Mon Sep 17 00:00:00 2001 From: MasaoFujii Date: Thu, 25 Aug 2016 15:29:30 +0900 Subject: [PATCH] Make pg_bigm handle new version numbering policy for PostgreSQL. --- pg_bigm--1.1--1.2.sql | 12 ++++++------ pg_bigm--1.2.sql | 12 ++++++------ 2 files changed, 12 insertions(+), 12 deletions(-) diff --git a/pg_bigm--1.1--1.2.sql b/pg_bigm--1.1--1.2.sql index a2bb7e9..ba52bca 100644 --- a/pg_bigm--1.1--1.2.sql +++ b/pg_bigm--1.1--1.2.sql @@ -4,10 +4,10 @@ /* triConsistent function is available only in 9.4 or later */ DO $$ DECLARE - pgversion TEXT; + pgversion INTEGER; BEGIN - SELECT current_setting('server_version_num') INTO pgversion; - IF pgversion >= '90400' THEN + SELECT current_setting('server_version_num')::INTEGER INTO pgversion; + IF pgversion >= 90400 THEN CREATE FUNCTION gin_bigm_triconsistent(internal, int2, text, int4, internal, internal, internal) RETURNS "char" AS 'MODULE_PATHNAME' @@ -21,10 +21,10 @@ $$; /* Label whether the function is deemed safe for parallelism */ DO $$ DECLARE - pgversion TEXT; + pgversion INTEGER; BEGIN - SELECT current_setting('server_version_num') INTO pgversion; - IF pgversion >= '90600' THEN + SELECT current_setting('server_version_num')::INTEGER INTO pgversion; + IF pgversion >= 90600 THEN ALTER FUNCTION show_bigm(text) PARALLEL SAFE; ALTER FUNCTION bigm_similarity(text, text) PARALLEL SAFE; ALTER FUNCTION bigm_similarity_op(text, text) PARALLEL SAFE; diff --git a/pg_bigm--1.2.sql b/pg_bigm--1.2.sql index 387e7b9..dec0f03 100644 --- a/pg_bigm--1.2.sql +++ b/pg_bigm--1.2.sql @@ -77,10 +77,10 @@ LANGUAGE C STRICT IMMUTABLE; /* triConsistent function is available only in 9.4 or later */ DO $$ DECLARE - pgversion TEXT; + pgversion INTEGER; BEGIN - SELECT current_setting('server_version_num') INTO pgversion; - IF pgversion >= '90400' THEN + SELECT current_setting('server_version_num')::INTEGER INTO pgversion; + IF pgversion >= 90400 THEN CREATE FUNCTION gin_bigm_triconsistent(internal, int2, text, int4, internal, internal, internal) RETURNS "char" AS 'MODULE_PATHNAME' @@ -94,10 +94,10 @@ $$; /* Label whether the function is deemed safe for parallelism */ DO $$ DECLARE - pgversion TEXT; + pgversion INTEGER; BEGIN - SELECT current_setting('server_version_num') INTO pgversion; - IF pgversion >= '90600' THEN + SELECT current_setting('server_version_num')::INTEGER INTO pgversion; + IF pgversion >= 90600 THEN ALTER FUNCTION show_bigm(text) PARALLEL SAFE; ALTER FUNCTION bigm_similarity(text, text) PARALLEL SAFE; ALTER FUNCTION bigm_similarity_op(text, text) PARALLEL SAFE; -- 2.11.0