Changeset: 163c1032997a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/163c1032997a
Modified Files:
        geom/monetdb5/geom_upgrade.c
        geom/sql/40_geom.sql
Branch: geo-update
Log Message:

Fixed GRANT command on filter functions.


diffs (30 lines):

diff --git a/geom/monetdb5/geom_upgrade.c b/geom/monetdb5/geom_upgrade.c
--- a/geom/monetdb5/geom_upgrade.c
+++ b/geom/monetdb5/geom_upgrade.c
@@ -38,9 +38,9 @@ geom_sql_upgrade(int olddb)
                        "CREATE FUNCTION ST_DistanceGeographic(geom1 Geometry, 
geom2 Geometry) RETURNS double EXTERNAL NAME geom.\"DistanceGeographic\";\n"
                        "GRANT EXECUTE ON FUNCTION 
ST_DistanceGeographic(Geometry, Geometry) TO PUBLIC;\n"
                        "CREATE FILTER FUNCTION ST_DWithinGeographic(geom1 
Geometry, geom2 Geometry, distance double) EXTERNAL NAME 
geom.\"DWithinGeographic\";\n"
-                       "GRANT EXECUTE ON FUNCTION 
ST_DWithinGeographic(Geometry, Geometry, double) TO PUBLIC;\n"
+                       "GRANT EXECUTE ON FILTER ST_DWithinGeographic(Geometry, 
Geometry, double) TO PUBLIC;\n"
                        "CREATE FILTER FUNCTION ST_IntersectsGeographic(geom1 
Geometry, geom2 Geometry) EXTERNAL NAME geom.\"IntersectsGeographic\";\n"
-                       "GRANT EXECUTE ON FUNCTION 
ST_IntersectsGeographic(Geometry, Geometry) TO PUBLIC;\n"
+                       "GRANT EXECUTE ON FILTER 
ST_IntersectsGeographic(Geometry, Geometry) TO PUBLIC;\n"
                        "CREATE AGGREGATE ST_Collect(geom Geometry) RETURNS 
Geometry external name aggr.\"Collect\";\n"
                        "GRANT EXECUTE ON AGGREGATE ST_Collect(Geometry) TO 
PUBLIC;\n"
                        "CREATE FILTER FUNCTION ST_Intersects(geom1 Geometry, 
geom2 Geometry) EXTERNAL NAME rtree.\"Intersects\";\n"
diff --git a/geom/sql/40_geom.sql b/geom/sql/40_geom.sql
--- a/geom/sql/40_geom.sql
+++ b/geom/sql/40_geom.sql
@@ -12,9 +12,9 @@
 CREATE FUNCTION ST_DistanceGeographic(geom1 Geometry, geom2 Geometry) RETURNS 
double EXTERNAL NAME geom."DistanceGeographic";
 GRANT EXECUTE ON FUNCTION ST_DistanceGeographic(Geometry, Geometry) TO PUBLIC;
 CREATE FILTER FUNCTION ST_DWithinGeographic(geom1 Geometry, geom2 Geometry, 
distance double) EXTERNAL NAME geom."DWithinGeographic";
-GRANT EXECUTE ON FUNCTION ST_DWithinGeographic(Geometry, Geometry, double) TO 
PUBLIC;
+GRANT EXECUTE ON FILTER ST_DWithinGeographic(Geometry, Geometry, double) TO 
PUBLIC;
 CREATE FILTER FUNCTION ST_IntersectsGeographic(geom1 Geometry, geom2 Geometry) 
EXTERNAL NAME geom."IntersectsGeographic";
-GRANT EXECUTE ON FUNCTION ST_IntersectsGeographic(Geometry, Geometry) TO 
PUBLIC;
+GRANT EXECUTE ON FILTER ST_IntersectsGeographic(Geometry, Geometry) TO PUBLIC;
 
 -------------------------------------------------------------------------
 ----------------------- New Geometry functions --------------------------
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to