--- /home/andrew/bf/root/upgrade.crake/HEAD/origin-REL_10_STABLE.sql.fixed 2021-09-12 16:07:51.164101299 -0400 +++ /home/andrew/bf/root/upgrade.crake/HEAD/converted-REL_10_STABLE-to-HEAD.sql.fixed 2021-09-12 16:07:51.194101299 -0400 @@ -166523,7 +166575,8 @@ -- CREATE TYPE public.arrayrange AS RANGE ( - subtype = integer[] + subtype = integer[], + multirange_type_name = public.arraymultirange ); @@ -166546,7 +166599,8 @@ -- CREATE TYPE public.cashrange AS RANGE ( - subtype = money + subtype = money, + multirange_type_name = public.cashmultirange ); @@ -166633,6 +166687,7 @@ INTERNALLENGTH = 16, INPUT = public.int44in, OUTPUT = public.int44out, + SUBSCRIPT = raw_array_subscript_handler, ELEMENT = integer, CATEGORY = 'x', PREFERRED = true, @@ -166680,6 +166735,7 @@ CREATE TYPE public.float8range AS RANGE ( subtype = double precision, + multirange_type_name = public.float8multirange, subtype_diff = float8mi ); @@ -167218,6 +167274,7 @@ CREATE TYPE public.textrange AS RANGE ( subtype = text, + multirange_type_name = public.textmultirange, collation = pg_catalog."C" );