Deprecate pgr_CreateTopology in 3.8 #2750
Description
New in version: 2.0.0
Reason for deprecation:
- Creates tables, indexes, etc based on predefined names.
- user needs higher permissions to use.
The user now has full control over what is needed:
Example:
SELECT * INTO vertices
FROM pgr_extractVertices('SELECT id, geom FROM edges ORDER BY id');
Finally using the data stored on the vertices tables the source and target are filled up.
/* -- set the source information */
UPDATE edges AS e
SET source = v.id
-- , x1 = x, y1 = y <-- any additional changes if needed
FROM vertices AS v
WHERE ST_StartPoint(e.geom) = v.geom;
/* -- set the target information */
UPDATE edges AS e
SET target = v.id
-- , x2 = x, y2 = y <-- any additional changes if needed
FROM vertices AS v
WHERE ST_EndPoint(e.geom) = v.geom;