[postgis-tickets] [SCM] PostGIS branch master updated. 3.2.0-698-g5fce0278a
git at osgeo.org
git at osgeo.org
Wed Apr 6 02:47:00 PDT 2022
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".
The branch, master has been updated
via 5fce0278a40012beb1f05bcb0751dcaffcf2ce42 (commit)
from b68342617e17bcdf800613d43b3a4fd2fe7dced5 (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 5fce0278a40012beb1f05bcb0751dcaffcf2ce42
Author: Sandro Santilli <strk at kbt.io>
Date: Wed Apr 6 11:46:41 2022 +0200
Fill in some topology functions availability info
diff --git a/doc/extras_topology.xml b/doc/extras_topology.xml
index ea270ee3d..6acdd550a 100644
--- a/doc/extras_topology.xml
+++ b/doc/extras_topology.xml
@@ -322,7 +322,7 @@ ERROR: value for domain topology.topoelementarray violates check constraint "di
<para>Valid <varname>feature_type</varname>s are: POINT, LINE, POLYGON, COLLECTION</para>
<!-- use this format if new function -->
- <para>Availability: 1.?</para>
+ <para>Availability: 1.1</para>
</refsection>
@@ -376,7 +376,7 @@ SELECT topology.AddTopoGeometryColumn('ri_topo', 'ri', 'roads', 'topo', 'LINE');
This function should be USED WITH CAUTION, as it could destroy data you care about. If the schema does not exist, it just removes reference entries the named schema.</para>
<!-- use this format if new function -->
- <para>Availability: 1.?</para>
+ <para>Availability: 1.1</para>
</refsection>
@@ -418,7 +418,7 @@ SELECT topology.AddTopoGeometryColumn('ri_topo', 'ri', 'roads', 'topo', 'LINE');
of drop status. NOTE: it first sets all values to NULL before dropping to bypass referential integrity checks.</para>
<!-- use this format if new function -->
- <para>Availability: 1.?</para>
+ <para>Availability: 1.1</para>
</refsection>
@@ -1019,7 +1019,8 @@ ANALYZE themselves, to use updated statistics.
<para>This is similar to the SQL/MM <xref linkend="ST_InitTopoGeo" /> but a bit more functional. <varname>hasz</varname> defaults to false if not specified.</para>
<!-- use this format if new function -->
- <para>Availability: 1.?</para>
+ <para>Availability: 1.1</para>
+ <para>Enhanched: 2.0 added the signature accepting hasZ</para>
</refsection>
@@ -1114,7 +1115,7 @@ This example makes a backup of a topology called ma_topo
<para>This is an SQL-MM equivalent of CreateTopology but lacks the spatial reference and tolerance options of CreateTopology and outputs a text description of creation instead of topology id.</para>
<!-- use this format if new function -->
- <para>Availability: 1.?</para>
+ <para>Availability: 1.1</para>
<para>&sqlmm_compliant; SQL-MM 3 Topo-Geo and Topo-Net 3: Routine Details: X.3.17</para>
</refsection>
@@ -1390,7 +1391,7 @@ up to caller, see <xref linkend="Topology_StatsManagement"/>.
<para>If <varname>aface</varname> is not null and the <varname>apoint</varname> is not within the face, then an exception is thrown.</para>
<!-- use this format if new function -->
- <para>Availability: 1.? </para>
+ <para>Availability: 1.1 </para>
<para>&sqlmm_compliant; SQL-MM: Topo-Net Routines: X+1.3.1</para>
</refsection>
@@ -1437,7 +1438,7 @@ up to caller, see <xref linkend="Topology_StatsManagement"/>.
<para>If the <varname>anode</varname> and <varname>anothernode</varname> are not the start and end points of the <varname>alinestring</varname> then an exception is thrown.</para>
<!-- use this format if new function -->
- <para>Availability: 1.? </para>
+ <para>Availability: 1.1 </para>
<para>&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.4</para>
</refsection>
@@ -2102,7 +2103,7 @@ SELECT topology.ST_NewEdgesSplit('ma_topo', 2, ST_GeomFromText('POINT(227578.5
<!-- use this format if new function -->
- <para>Availability: 1.? </para>
+ <para>Availability: 1.1 </para>
<para>&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X+1.3.3</para>
</refsection>
@@ -2149,7 +2150,7 @@ SELECT topology.ST_RemoveIsoNode('ma_topo', 7 ) As result;
<!-- use this format if new function -->
- <para>Availability: 1.? </para>
+ <para>Availability: 1.1 </para>
<para>&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X+1.3.3</para>
</refsection>
@@ -2423,7 +2424,7 @@ ERROR: Two or more faces found</programlisting>
<para>Returns the id of a topology in the topology.topology table given the name of the topology.</para>
<!-- use this format if new function -->
- <para>Availability: 1.?</para>
+ <para>Availability: 1.1</para>
</refsection>
@@ -2513,7 +2514,7 @@ ERROR: Two or more faces found</programlisting>
<para>Returns the topology name (schema) of a topology from the topology.topology table given the topology id of the topology.</para>
<!-- use this format if new function -->
- <para>Availability: 1.?</para>
+ <para>Availability: 1.1</para>
</refsection>
@@ -2632,7 +2633,7 @@ FROM topology.ST_GetFaceEdges('tt',1) As t(seq,edge)
<!-- use this format if new function -->
- <para>Availability: 1.? </para>
+ <para>Availability: 1.1 </para>
<para>&sqlmm_compliant; SQL-MM 3 Topo-Geo and Topo-Net 3: Routine Details: X.3.16</para>
</refsection>
@@ -3137,7 +3138,7 @@ faceid
and collections can be formed from a mixture of nodes, edges, and faces.</para>
<para>Omitting the array of components generates an empty TopoGeometry object.</para>
<!-- use this format if new function -->
- <para>Availability: 1.?</para>
+ <para>Availability: 1.1</para>
</refsection>
@@ -3639,7 +3640,7 @@ Refer to <xref linkend="toTopoGeom" />.
<para>tg_id is the topogeometry id of the topogeometry object in the topology in the layer denoted by <varname>layer_id</varname> in the topology.layer table.</para>
<!-- use this format if new function -->
- <para>Availability: 1.?</para>
+ <para>Availability: 1.1</para>
</refsection>
diff --git a/topology/sql/manage/CreateTopology.sql.in b/topology/sql/manage/CreateTopology.sql.in
index a637e5487..c7fe5709a 100644
--- a/topology/sql/manage/CreateTopology.sql.in
+++ b/topology/sql/manage/CreateTopology.sql.in
@@ -21,6 +21,8 @@
-- in the topology.topology relation, return it's numeric
-- id.
--
+-- Availability: 2.0.0
+--
CREATE OR REPLACE FUNCTION topology.CreateTopology(atopology varchar, srid integer, prec float8, hasZ boolean)
RETURNS integer
AS
@@ -267,18 +269,21 @@ LANGUAGE 'plpgsql' VOLATILE STRICT;
--{ CreateTopology wrappers for unspecified srid or precision or hasZ
-- CreateTopology(name, SRID, precision) -- hasZ = false
+-- Availability: 1.1.0
CREATE OR REPLACE FUNCTION topology.CreateTopology(toponame varchar, srid integer, prec float8)
RETURNS integer AS
' SELECT topology.CreateTopology($1, $2, $3, false);'
LANGUAGE 'sql' VOLATILE STRICT;
-- CreateTopology(name, SRID) -- precision = 0
+-- Availability: 1.1.0
CREATE OR REPLACE FUNCTION topology.CreateTopology(varchar, integer)
RETURNS integer AS
' SELECT topology.CreateTopology($1, $2, 0); '
LANGUAGE 'sql' VOLATILE STRICT;
-- CreateTopology(name) -- srid = unknown, precision = 0
+-- Availability: 1.1.0
CREATE OR REPLACE FUNCTION topology.CreateTopology(varchar)
RETURNS integer AS
$$ SELECT topology.CreateTopology($1, ST_SRID('POINT EMPTY'::geometry), 0); $$
diff --git a/topology/sql/sqlmm.sql.in b/topology/sql/sqlmm.sql.in
index a2f41d310..4ff6a51a2 100644
--- a/topology/sql/sqlmm.sql.in
+++ b/topology/sql/sqlmm.sql.in
@@ -25,6 +25,8 @@
--
-- Type returned by ST_GetFaceEdges
--
+-- Availability: 1.1.0
+--
CREATE TYPE topology.GetFaceEdges_ReturnType AS (
sequence integer,
edge integer
@@ -36,7 +38,7 @@ CREATE TYPE topology.GetFaceEdges_ReturnType AS (
--
-- ST_GetFaceEdges(atopology, aface)
--
---
+-- Availability: 1.1.0
--
CREATE OR REPLACE FUNCTION topology.ST_GetFaceEdges(toponame varchar, face_id integer)
RETURNS SETOF topology.GetFaceEdges_ReturnType AS
@@ -146,6 +148,8 @@ CREATE OR REPLACE FUNCTION topology.ST_GetFaceGeometry(toponame varchar, aface i
--
-- ST_AddIsoNode(atopology, aface, apoint)
--
+-- Availability: 1.1.0
+--
CREATE OR REPLACE FUNCTION topology.ST_AddIsoNode(atopology varchar, aface integer, apoint geometry)
RETURNS INTEGER AS
'MODULE_PATHNAME','ST_AddIsoNode'
@@ -170,6 +174,8 @@ CREATE OR REPLACE FUNCTION topology.ST_MoveIsoNode(atopology character varying,
--
-- ST_RemoveIsoNode(atopology, anode)
--
+-- Availability: 1.1.0
+--
CREATE OR REPLACE FUNCTION topology.ST_RemoveIsoNode(atopology varchar, anode integer)
RETURNS TEXT AS
'MODULE_PATHNAME','ST_RemoveIsoNode'
@@ -193,6 +199,8 @@ CREATE OR REPLACE FUNCTION topology.ST_RemIsoNode(varchar, integer)
--
-- ST_RemoveIsoEdge(atopology, anedge)
--
+-- Availability: 1.1.0
+--
CREATE OR REPLACE FUNCTION topology.ST_RemoveIsoEdge(atopology varchar, anedge integer)
RETURNS TEXT AS
'MODULE_PATHNAME','ST_RemIsoEdge'
@@ -241,6 +249,8 @@ CREATE OR REPLACE FUNCTION topology.ST_ModEdgeSplit(atopology varchar, anedge in
-- * Refuse to add a closed edge, as it would not be isolated
-- (ie: would create a ring)
--
+-- Availability: 1.1.0
+--
-- }{
--
CREATE OR REPLACE FUNCTION topology.ST_AddIsoEdge(atopology varchar, anode integer, anothernode integer, acurve geometry)
@@ -343,6 +353,8 @@ CREATE OR REPLACE FUNCTION topology.ST_AddEdgeModFace(atopology varchar, anode i
--
-- ST_InitTopoGeo(atopology)
--
+-- Availability: 1.1.0
+--
CREATE OR REPLACE FUNCTION topology.ST_InitTopoGeo(atopology varchar)
RETURNS text
AS
diff --git a/topology/topology.sql.in b/topology/topology.sql.in
index ebc62a5af..50f408d38 100644
--- a/topology/topology.sql.in
+++ b/topology/topology.sql.in
@@ -542,6 +542,7 @@ LANGUAGE 'plpgsql' VOLATILE STRICT;
-- Add a TopoGeometry column to a table, making it a topology layer.
-- Returns created layer id.
--
+-- Availability: 1.1.0
--
CREATE OR REPLACE FUNCTION topology.AddTopoGeometryColumn(toponame varchar, schema varchar, tbl varchar, col varchar, ltype varchar, child integer)
RETURNS integer
@@ -712,6 +713,7 @@ LANGUAGE 'sql' VOLATILE;
-- Drop a TopoGeometry column, unregister the associated layer,
-- cleanup the relation table.
--
+-- Availability: 1.1.0
--
CREATE OR REPLACE FUNCTION topology.DropTopoGeometryColumn(schema varchar, tbl varchar, col varchar)
RETURNS text
@@ -886,6 +888,8 @@ LANGUAGE 'sql' VOLATILE;
--
-- Return a topology.TopoGeometry object.
--
+-- Availability: 1.1.0
+--
CREATE OR REPLACE FUNCTION topology.CreateTopoGeom(toponame varchar, tg_type integer, layer_id integer, tg_objs topology.TopoElementArray)
RETURNS topology.TopoGeometry
AS
@@ -1007,6 +1011,7 @@ LANGUAGE 'plpgsql' VOLATILE STRICT;
--{
-- CreateTopoGeom(topology_name, topogeom_type, layer_id) - creates the empty topogeom
+-- Availability: 1.1.0
CREATE OR REPLACE FUNCTION topology.CreateTopoGeom(toponame varchar, tg_type integer, layer_id integer)
RETURNS topology.TopoGeometry
AS
@@ -1018,7 +1023,9 @@ $$ LANGUAGE 'sql' VOLATILE STRICT;
--{
-- GetTopologyName(topology_id)
--
--- TODO: rewrite in SQL ?
+-- TODO: rewrite in SQL, as a wrapper around findTopology
+--
+-- Availability: 1.1.0
--
CREATE OR REPLACE FUNCTION topology.GetTopologyName(topoid integer)
RETURNS varchar
@@ -1038,7 +1045,9 @@ LANGUAGE 'plpgsql' STABLE STRICT;
--{
-- GetTopologyId(toponame)
--
--- TODO: rewrite in SQL ?
+-- TODO: rewrite in SQL, as a wrapper around findTopology
+--
+-- Availability: 1.1.0
--
CREATE OR REPLACE FUNCTION topology.GetTopologyId(toponame varchar)
RETURNS integer
@@ -1076,6 +1085,8 @@ $$ LANGUAGE 'sql' STABLE STRICT;
--
-- Returns a set of element_id,element_type
--
+-- Availability: 1.1.0
+--
CREATE OR REPLACE FUNCTION topology.GetTopoGeomElementArray(toponame varchar, layer_id integer, tgid integer)
RETURNS topology.TopoElementArray
AS
@@ -1440,6 +1451,8 @@ CREATE CAST (topology.TopoGeometry AS Geometry) WITH FUNCTION topology.Geometry(
--
-- Drops a topology schema getting rid of every dependent object.
--
+-- Availability: 1.1.0
+--
CREATE OR REPLACE FUNCTION topology.DropTopology(atopology varchar)
RETURNS text
AS
-----------------------------------------------------------------------
Summary of changes:
doc/extras_topology.xml | 29 +++++++++++++++--------------
topology/sql/manage/CreateTopology.sql.in | 5 +++++
topology/sql/sqlmm.sql.in | 14 +++++++++++++-
topology/topology.sql.in | 17 +++++++++++++++--
4 files changed, 48 insertions(+), 17 deletions(-)
hooks/post-receive
--
PostGIS
More information about the postgis-tickets
mailing list