[postgis-tickets] [SCM] PostGIS; Spatial objects for PostgreSQL. branch master updated. 5df3bbbf927e10b16905d915ee7880e9498bf9c3

[git at osgeo.org]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS; Spatial objects for PostgreSQL.".

The branch, master has been updated
       via  5df3bbbf927e10b16905d915ee7880e9498bf9c3 (commit)
       via  5fb9aa680ba1516d1ad898f851f3a68345203587 (commit)
      from  ff0845764e7fdb182abf2f5d5f0df1d1fc64bcd3 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 5df3bbbf927e10b16905d915ee7880e9498bf9c3
Author: Raúl Marín <git at rmr.ninja>
Date:   Fri Nov 15 15:46:43 2019 +0100

    postgis/postgis.sql.in: Add missing parallel tags

diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
index 0234963..e3c93a1 100644
--- a/postgis/postgis.sql.in
+++ b/postgis/postgis.sql.in
@@ -4987,7 +4987,7 @@ CREATE OR REPLACE FUNCTION ST_AsText(geometry)
 CREATE OR REPLACE FUNCTION ST_AsText(geometry, int4)
     RETURNS TEXT
     AS 'MODULE_PATHNAME','LWGEOM_asText'
-    LANGUAGE 'c' IMMUTABLE STRICT
+    LANGUAGE 'c' IMMUTABLE STRICT PARALLEL SAFE
     _COST_MEDIUM;
 
 -- Availability: 1.2.2
@@ -6232,7 +6232,7 @@ CREATE OR REPLACE FUNCTION ST_AsX3D(geom geometry, maxdecimaldigits integer DEFA
 -- has to be here because need ST_StartPoint
 CREATE OR REPLACE FUNCTION ST_Angle(line1 geometry, line2 geometry)
 	RETURNS float8 AS 'SELECT ST_Angle(St_StartPoint($1), ST_EndPoint($1), St_StartPoint($2), ST_EndPoint($2))'
-	LANGUAGE 'sql' IMMUTABLE STRICT;
+	LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
 
 -- make views and spatial_ref_sys public viewable --
 GRANT SELECT ON TABLE geography_columns TO public;

commit 5fb9aa680ba1516d1ad898f851f3a68345203587
Author: Raúl Marín <git at rmr.ninja>
Date:   Fri Nov 15 15:46:25 2019 +0100

    Add parallellism and cost properties to brin functions
    
    Closes #4578

diff --git a/postgis/postgis_brin.sql.in b/postgis/postgis_brin.sql.in
index 369e00e..340dd1f 100644
--- a/postgis/postgis_brin.sql.in
+++ b/postgis/postgis_brin.sql.in
@@ -11,37 +11,37 @@
 CREATE OR REPLACE FUNCTION contains_2d(box2df, geometry)
 RETURNS boolean
 AS 'MODULE_PATHNAME','gserialized_contains_box2df_geom_2d'
-LANGUAGE 'c' IMMUTABLE STRICT;
+LANGUAGE 'c' IMMUTABLE STRICT PARALLEL SAFE _COST_DEFAULT;
 
 -- Availability: 2.3.0
 CREATE OR REPLACE FUNCTION is_contained_2d(box2df, geometry)
 RETURNS boolean
 AS 'MODULE_PATHNAME','gserialized_within_box2df_geom_2d'
-LANGUAGE 'c' IMMUTABLE STRICT;
+LANGUAGE 'c' IMMUTABLE STRICT PARALLEL SAFE _COST_DEFAULT;
 
 -- Availability: 2.3.0
 CREATE OR REPLACE FUNCTION overlaps_2d(box2df, geometry)
 RETURNS boolean
 AS 'MODULE_PATHNAME','gserialized_overlaps_box2df_geom_2d'
-LANGUAGE 'c' IMMUTABLE STRICT;
+LANGUAGE 'c' IMMUTABLE STRICT PARALLEL SAFE _COST_DEFAULT;
 
 -- Availability: 2.3.0
 CREATE OR REPLACE FUNCTION overlaps_2d(box2df, box2df)
 RETURNS boolean
 AS 'MODULE_PATHNAME','gserialized_contains_box2df_box2df_2d'
-LANGUAGE 'c' IMMUTABLE STRICT;
+LANGUAGE 'c' IMMUTABLE STRICT PARALLEL SAFE _COST_DEFAULT;
 
 -- Availability: 2.3.0
 CREATE OR REPLACE FUNCTION contains_2d(box2df, box2df)
 RETURNS boolean
 AS 'MODULE_PATHNAME','gserialized_contains_box2df_box2df_2d'
-LANGUAGE 'c' IMMUTABLE STRICT;
+LANGUAGE 'c' IMMUTABLE STRICT PARALLEL SAFE _COST_DEFAULT;
 
 -- Availability: 2.3.0
 CREATE OR REPLACE FUNCTION is_contained_2d(box2df, box2df)
 RETURNS boolean
 AS 'MODULE_PATHNAME','gserialized_contains_box2df_box2df_2d'
-LANGUAGE 'c' IMMUTABLE STRICT;
+LANGUAGE 'c' IMMUTABLE STRICT PARALLEL SAFE _COST_DEFAULT;
 
 -- Availability: 2.3.0
 CREATE OPERATOR ~ (
@@ -72,21 +72,21 @@ CREATE OR REPLACE FUNCTION contains_2d(geometry, box2df)
 RETURNS boolean
 AS
 	'SELECT $2 OPERATOR(@extschema at .@) $1;'
-LANGUAGE SQL IMMUTABLE STRICT;
+LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE _COST_DEFAULT;
 
 -- Availability: 2.3.0
 CREATE OR REPLACE FUNCTION is_contained_2d(geometry, box2df)
 RETURNS boolean
 AS
 	'SELECT $2 OPERATOR(@extschema at .~) $1;'
-LANGUAGE SQL IMMUTABLE STRICT;
+LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE _COST_DEFAULT;
 
 -- Availability: 2.3.0
 CREATE OR REPLACE FUNCTION overlaps_2d(geometry, box2df)
 RETURNS boolean
 AS
 	'SELECT $2 OPERATOR(@extschema at .&&) $1;'
-LANGUAGE SQL IMMUTABLE STRICT;
+LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE _COST_DEFAULT;
 
 -- Availability: 2.3.0
 CREATE OPERATOR ~ (
@@ -139,13 +139,13 @@ CREATE OPERATOR ~ (
 CREATE OR REPLACE FUNCTION overlaps_nd(gidx, geometry)
 RETURNS boolean
 AS 'MODULE_PATHNAME','gserialized_gidx_geom_overlaps'
-LANGUAGE 'c' IMMUTABLE STRICT;
+LANGUAGE 'c' IMMUTABLE STRICT PARALLEL SAFE _COST_DEFAULT;
 
 -- Availability: 2.3.0
 CREATE OR REPLACE FUNCTION overlaps_nd(gidx, gidx)
 RETURNS boolean
 AS 'MODULE_PATHNAME','gserialized_gidx_gidx_overlaps'
-LANGUAGE 'c' IMMUTABLE STRICT;
+LANGUAGE 'c' IMMUTABLE STRICT PARALLEL SAFE _COST_DEFAULT;
 
 -- Availability: 2.3.0
 CREATE OPERATOR &&& (
@@ -160,7 +160,7 @@ CREATE OR REPLACE FUNCTION overlaps_nd(geometry, gidx)
 RETURNS boolean
 AS
 	'SELECT $2 OPERATOR(@extschema at .&&&) $1;'
-LANGUAGE SQL IMMUTABLE STRICT;
+LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE _COST_DEFAULT;
 
 -- Availability: 2.3.0
 CREATE OPERATOR &&& (
@@ -187,19 +187,22 @@ CREATE OPERATOR &&& (
 	-------------
 
 -- Availability: 2.3.0
-CREATE OR REPLACE FUNCTION geom2d_brin_inclusion_add_value(internal, internal, internal, internal) RETURNS boolean
-	AS 'MODULE_PATHNAME','geom2d_brin_inclusion_add_value'
-	LANGUAGE 'c';
+CREATE OR REPLACE FUNCTION geom2d_brin_inclusion_add_value(internal, internal, internal, internal)
+RETURNS boolean
+AS 'MODULE_PATHNAME','geom2d_brin_inclusion_add_value'
+LANGUAGE 'c' PARALLEL SAFE _COST_DEFAULT;
 
 -- Availability: 2.3.0
-CREATE OR REPLACE FUNCTION geom3d_brin_inclusion_add_value(internal, internal, internal, internal) RETURNS boolean
-	AS 'MODULE_PATHNAME','geom3d_brin_inclusion_add_value'
-	LANGUAGE 'c';
+CREATE OR REPLACE FUNCTION geom3d_brin_inclusion_add_value(internal, internal, internal, internal)
+RETURNS boolean
+AS 'MODULE_PATHNAME','geom3d_brin_inclusion_add_value'
+LANGUAGE 'c' PARALLEL SAFE _COST_DEFAULT;
 
 -- Availability: 2.3.0
-CREATE OR REPLACE FUNCTION geom4d_brin_inclusion_add_value(internal, internal, internal, internal) RETURNS boolean
-	AS 'MODULE_PATHNAME','geom4d_brin_inclusion_add_value'
-	LANGUAGE 'c';
+CREATE OR REPLACE FUNCTION geom4d_brin_inclusion_add_value(internal, internal, internal, internal)
+RETURNS boolean
+AS 'MODULE_PATHNAME','geom4d_brin_inclusion_add_value'
+LANGUAGE 'c' PARALLEL SAFE _COST_DEFAULT;
 
 -- Availability: 2.3.0
 CREATE OPERATOR CLASS brin_geometry_inclusion_ops_2d

-----------------------------------------------------------------------

Summary of changes:
 postgis/postgis.sql.in      |  4 ++--
 postgis/postgis_brin.sql.in | 45 ++++++++++++++++++++++++---------------------
 2 files changed, 26 insertions(+), 23 deletions(-)


hooks/post-receive
-- 
PostGIS; Spatial objects for PostgreSQL.