On 06/10/2016 01:44 PM, Andreas Karlsson wrote:
I have attached a patch which adds the shcema, plus an updated patch for tseach2.
Forgot adding schema to the tables. Here are new versions. Andreas
parallel-contrib-v4-tsearch2.patch.gz
Description: application/gzip
diff --git a/contrib/citext/citext--1.1--1.2.sql b/contrib/citext/citext--1.1--1.2.sql index 60dd15b..a6a30e9 100644 --- a/contrib/citext/citext--1.1--1.2.sql +++ b/contrib/citext/citext--1.1--1.2.sql @@ -41,14 +41,14 @@ ALTER FUNCTION replace(citext, citext, citext) PARALLEL SAFE; ALTER FUNCTION split_part(citext, citext, int) PARALLEL SAFE; ALTER FUNCTION translate(citext, citext, text) PARALLEL SAFE; -UPDATE pg_proc SET proparallel = 's' -WHERE oid = 'min(citext)'::regprocedure; +UPDATE pg_catalog.pg_proc SET proparallel = 's' +WHERE oid = 'min(citext)'::pg_catalog.regprocedure; -UPDATE pg_proc SET proparallel = 's' -WHERE oid = 'max(citext)'::regprocedure; +UPDATE pg_catalog.pg_proc SET proparallel = 's' +WHERE oid = 'max(citext)'::pg_catalog.regprocedure; -UPDATE pg_aggregate SET aggcombinefn = 'citext_smaller' -WHERE aggfnoid = 'max(citext)'::regprocedure; +UPDATE pg_catalog.pg_aggregate SET aggcombinefn = 'citext_smaller' +WHERE aggfnoid = 'max(citext)'::pg_catalog.regprocedure; -UPDATE pg_aggregate SET aggcombinefn = 'citext_larger' -WHERE aggfnoid = 'max(citext)'::regprocedure; +UPDATE pg_catalog.pg_aggregate SET aggcombinefn = 'citext_larger' +WHERE aggfnoid = 'max(citext)'::pg_catalog.regprocedure; diff --git a/contrib/intagg/intagg--1.0--1.1.sql b/contrib/intagg/intagg--1.0--1.1.sql index 2ec95b6..d9a8705 100644 --- a/contrib/intagg/intagg--1.0--1.1.sql +++ b/contrib/intagg/intagg--1.0--1.1.sql @@ -7,5 +7,5 @@ ALTER FUNCTION int_agg_state(internal, int4) PARALLEL SAFE; ALTER FUNCTION int_agg_final_array(internal) PARALLEL SAFE; ALTER FUNCTION int_array_enum(int4[]) PARALLEL SAFE; -UPDATE pg_proc SET proparallel = 's' -WHERE oid = 'int_array_aggregate(int4)'::regprocedure; +UPDATE pg_catalog.pg_proc SET proparallel = 's' +WHERE oid = 'int_array_aggregate(int4)'::pg_catalog.regprocedure;
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
