dumpdiff-REL_13_STABLE
text/plain
Filename: dumpdiff-REL_13_STABLE
Type: text/plain
Part: 9
--- /home/andrew/bf/root/upgrade.crake/HEAD/origin-REL_13_STABLE.sql.fixed 2021-09-12 16:14:12.048111840 -0400
+++ /home/andrew/bf/root/upgrade.crake/HEAD/converted-REL_13_STABLE-to-HEAD.sql.fixed 2021-09-12 16:14:12.100111841 -0400
@@ -170167,7 +170167,7 @@
-- Name: test_proc6(integer, integer, integer); Type: PROCEDURE; Schema: public; Owner: buildfarm
--
-CREATE PROCEDURE public.test_proc6(a integer, INOUT b integer, INOUT c integer)
+CREATE PROCEDURE public.test_proc6(IN a integer, INOUT b integer, INOUT c integer)
LANGUAGE plperl
AS $_$
my ($a, $b, $c) = @_;
@@ -170175,7 +170175,7 @@
$_$;
-ALTER PROCEDURE public.test_proc6(a integer, INOUT b integer, INOUT c integer) OWNER TO buildfarm;
+ALTER PROCEDURE public.test_proc6(IN a integer, INOUT b integer, INOUT c integer) OWNER TO buildfarm;
--
-- Name: text_arrayref(); Type: FUNCTION; Schema: public; Owner: buildfarm
@@ -171155,7 +171155,7 @@
-- Name: p1(integer, text); Type: PROCEDURE; Schema: public; Owner: buildfarm
--
-CREATE PROCEDURE public.p1(v_cnt integer, INOUT v_text text DEFAULT NULL::text)
+CREATE PROCEDURE public.p1(IN v_cnt integer, INOUT v_text text DEFAULT NULL::text)
LANGUAGE plpgsql
AS $$
BEGIN
@@ -171164,7 +171164,7 @@
$$;
-ALTER PROCEDURE public.p1(v_cnt integer, INOUT v_text text) OWNER TO buildfarm;
+ALTER PROCEDURE public.p1(IN v_cnt integer, INOUT v_text text) OWNER TO buildfarm;
--
-- Name: read_ordered_int8s(public.ordered_int8s); Type: FUNCTION; Schema: public; Owner: buildfarm
@@ -171686,7 +171686,7 @@
-- Name: test_proc6(integer, integer, integer); Type: PROCEDURE; Schema: public; Owner: buildfarm
--
-CREATE PROCEDURE public.test_proc6(a integer, INOUT b integer, INOUT c integer)
+CREATE PROCEDURE public.test_proc6(IN a integer, INOUT b integer, INOUT c integer)
LANGUAGE plpgsql
AS $$
BEGIN
@@ -171696,13 +171696,13 @@
$$;
-ALTER PROCEDURE public.test_proc6(a integer, INOUT b integer, INOUT c integer) OWNER TO buildfarm;
+ALTER PROCEDURE public.test_proc6(IN a integer, INOUT b integer, INOUT c integer) OWNER TO buildfarm;
--
-- Name: test_proc7(integer, integer, numeric); Type: PROCEDURE; Schema: public; Owner: buildfarm
--
-CREATE PROCEDURE public.test_proc7(x integer, INOUT a integer, INOUT b numeric)
+CREATE PROCEDURE public.test_proc7(IN x integer, INOUT a integer, INOUT b numeric)
LANGUAGE plpgsql
AS $$
BEGIN
@@ -171715,13 +171715,13 @@
$$;
-ALTER PROCEDURE public.test_proc7(x integer, INOUT a integer, INOUT b numeric) OWNER TO buildfarm;
+ALTER PROCEDURE public.test_proc7(IN x integer, INOUT a integer, INOUT b numeric) OWNER TO buildfarm;
--
-- Name: test_proc7c(integer, integer, numeric); Type: PROCEDURE; Schema: public; Owner: buildfarm
--
-CREATE PROCEDURE public.test_proc7c(x integer, INOUT a integer, INOUT b numeric)
+CREATE PROCEDURE public.test_proc7c(IN x integer, INOUT a integer, INOUT b numeric)
LANGUAGE plpgsql
AS $$
BEGIN
@@ -171732,13 +171732,13 @@
$$;
-ALTER PROCEDURE public.test_proc7c(x integer, INOUT a integer, INOUT b numeric) OWNER TO buildfarm;
+ALTER PROCEDURE public.test_proc7c(IN x integer, INOUT a integer, INOUT b numeric) OWNER TO buildfarm;
--
-- Name: test_proc7cc(integer); Type: PROCEDURE; Schema: public; Owner: buildfarm
--
-CREATE PROCEDURE public.test_proc7cc(_x integer)
+CREATE PROCEDURE public.test_proc7cc(IN _x integer)
LANGUAGE plpgsql
AS $$
DECLARE _a int; _b numeric;
@@ -171749,7 +171749,7 @@
$$;
-ALTER PROCEDURE public.test_proc7cc(_x integer) OWNER TO buildfarm;
+ALTER PROCEDURE public.test_proc7cc(IN _x integer) OWNER TO buildfarm;
--
-- Name: test_proc8a(integer, integer); Type: PROCEDURE; Schema: public; Owner: buildfarm
@@ -171882,7 +171882,7 @@
-- Name: transaction_test1(integer, text); Type: PROCEDURE; Schema: public; Owner: buildfarm
--
-CREATE PROCEDURE public.transaction_test1(x integer, y text)
+CREATE PROCEDURE public.transaction_test1(IN x integer, IN y text)
LANGUAGE plpgsql
AS $$
BEGIN
@@ -171898,7 +171898,7 @@
$$;
-ALTER PROCEDURE public.transaction_test1(x integer, y text) OWNER TO buildfarm;
+ALTER PROCEDURE public.transaction_test1(IN x integer, IN y text) OWNER TO buildfarm;
--
-- Name: transaction_test10a(integer); Type: PROCEDURE; Schema: public; Owner: buildfarm
@@ -172058,7 +172058,7 @@
-- Name: transaction_test6(text); Type: PROCEDURE; Schema: public; Owner: buildfarm
--
-CREATE PROCEDURE public.transaction_test6(c text)
+CREATE PROCEDURE public.transaction_test6(IN c text)
LANGUAGE plpgsql
AS $$
BEGIN
@@ -172067,7 +172067,7 @@
$$;
-ALTER PROCEDURE public.transaction_test6(c text) OWNER TO buildfarm;
+ALTER PROCEDURE public.transaction_test6(IN c text) OWNER TO buildfarm;
--
-- Name: transaction_test7(); Type: PROCEDURE; Schema: public; Owner: buildfarm
@@ -174390,7 +174390,7 @@
-- Name: test_proc6(integer, integer, integer); Type: PROCEDURE; Schema: public; Owner: buildfarm
--
-CREATE PROCEDURE public.test_proc6(a integer, INOUT b integer, INOUT c integer)
+CREATE PROCEDURE public.test_proc6(IN a integer, INOUT b integer, INOUT c integer)
LANGUAGE pltcl
AS $_$
set bb [expr $2 * $1]
@@ -174399,7 +174399,7 @@
$_$;
-ALTER PROCEDURE public.test_proc6(a integer, INOUT b integer, INOUT c integer) OWNER TO buildfarm;
+ALTER PROCEDURE public.test_proc6(IN a integer, INOUT b integer, INOUT c integer) OWNER TO buildfarm;
--
-- Name: transaction_test1(); Type: PROCEDURE; Schema: public; Owner: buildfarm
@@ -175433,7 +175433,8 @@
--
CREATE TYPE public.arrayrange AS RANGE (
- subtype = integer[]
+ subtype = integer[],
+ multirange_type_name = public.arraymultirange
);
@@ -175456,7 +175457,8 @@
--
CREATE TYPE public.cashrange AS RANGE (
- subtype = money
+ subtype = money,
+ multirange_type_name = public.cashmultirange
);
@@ -175543,6 +175545,7 @@
INTERNALLENGTH = 16,
INPUT = public.int44in,
OUTPUT = public.int44out,
+ SUBSCRIPT = raw_array_subscript_handler,
ELEMENT = integer,
CATEGORY = 'x',
PREFERRED = true,
@@ -175590,6 +175593,7 @@
CREATE TYPE public.float8range AS RANGE (
subtype = double precision,
+ multirange_type_name = public.float8multirange,
subtype_diff = float8mi
);
@@ -176138,6 +176142,7 @@
CREATE TYPE public.textrange AS RANGE (
subtype = text,
+ multirange_type_name = public.textmultirange,
collation = pg_catalog."C"
);
@@ -178259,7 +178264,7 @@
-- Name: ptest3(text); Type: PROCEDURE; Schema: public; Owner: buildfarm
--
-CREATE PROCEDURE public.ptest3(y text)
+CREATE PROCEDURE public.ptest3(IN y text)
LANGUAGE sql
AS $_$
CALL ptest1(y);
@@ -178267,13 +178272,13 @@
$_$;
-ALTER PROCEDURE public.ptest3(y text) OWNER TO buildfarm;
+ALTER PROCEDURE public.ptest3(IN y text) OWNER TO buildfarm;
--
-- Name: ptest5(integer, text, integer); Type: PROCEDURE; Schema: public; Owner: buildfarm
--
-CREATE PROCEDURE public.ptest5(a integer, b text, c integer DEFAULT 100)
+CREATE PROCEDURE public.ptest5(IN a integer, IN b text, IN c integer DEFAULT 100)
LANGUAGE sql
AS $$
INSERT INTO cp_test VALUES(a, b);
@@ -178281,33 +178286,33 @@
$$;
-ALTER PROCEDURE public.ptest5(a integer, b text, c integer) OWNER TO buildfarm;
+ALTER PROCEDURE public.ptest5(IN a integer, IN b text, IN c integer) OWNER TO buildfarm;
--
-- Name: ptest6(integer, anyelement); Type: PROCEDURE; Schema: public; Owner: buildfarm
--
-CREATE PROCEDURE public.ptest6(a integer, b anyelement)
+CREATE PROCEDURE public.ptest6(IN a integer, IN b anyelement)
LANGUAGE sql
AS $$
SELECT NULL::int;
$$;
-ALTER PROCEDURE public.ptest6(a integer, b anyelement) OWNER TO buildfarm;
+ALTER PROCEDURE public.ptest6(IN a integer, IN b anyelement) OWNER TO buildfarm;
--
-- Name: ptest7(text, text); Type: PROCEDURE; Schema: public; Owner: buildfarm
--
-CREATE PROCEDURE public.ptest7(a text, b text)
+CREATE PROCEDURE public.ptest7(IN a text, IN b text)
LANGUAGE sql
AS $$
SELECT a = b;
$$;
-ALTER PROCEDURE public.ptest7(a text, b text) OWNER TO buildfarm;
+ALTER PROCEDURE public.ptest7(IN a text, IN b text) OWNER TO buildfarm;
--
-- Name: raise_test3(integer); Type: FUNCTION; Schema: public; Owner: buildfarm
@@ -181298,6 +181303,8 @@
--
CREATE OPERATOR FAMILY public.part_test_int4_ops USING hash;
+ALTER OPERATOR FAMILY public.part_test_int4_ops USING hash ADD
+ FUNCTION 2 (integer, integer) public.part_hashint4_noop(integer,bigint);
ALTER OPERATOR FAMILY public.part_test_int4_ops USING hash OWNER TO buildfarm;
@@ -181308,8 +181315,7 @@
CREATE OPERATOR CLASS public.part_test_int4_ops
FOR TYPE integer USING hash FAMILY public.part_test_int4_ops AS
- OPERATOR 1 =(integer,integer) ,
- FUNCTION 2 (integer, integer) public.part_hashint4_noop(integer,bigint);
+ OPERATOR 1 =(integer,integer);
ALTER OPERATOR CLASS public.part_test_int4_ops USING hash OWNER TO buildfarm;
@@ -181328,6 +181334,8 @@
--
CREATE OPERATOR FAMILY public.part_test_text_ops USING hash;
+ALTER OPERATOR FAMILY public.part_test_text_ops USING hash ADD
+ FUNCTION 2 (text, text) public.part_hashtext_length(text,bigint);
ALTER OPERATOR FAMILY public.part_test_text_ops USING hash OWNER TO buildfarm;
@@ -181338,8 +181346,7 @@
CREATE OPERATOR CLASS public.part_test_text_ops
FOR TYPE text USING hash FAMILY public.part_test_text_ops AS
- OPERATOR 1 =(text,text) ,
- FUNCTION 2 (text, text) public.part_hashtext_length(text,bigint);
+ OPERATOR 1 =(text,text);
ALTER OPERATOR CLASS public.part_test_text_ops USING hash OWNER TO buildfarm;