[pgrouting-dev] pgRouting version 3.6.0 release

Hello pgRouting community,

The pgRouting Team is pleased to announce the release of pgRouting version 3.6.0
The latest release is available at [1]
For discussions on the release, go to [2]

To see all issues & pull requests closed by this release see the Git closed milestone for 3.6.0 on Github. [3]

Official functions changes

  • #2516 Standarize output pgr_aStar
  • Standarizing output columns to (seq, path_seq, start_vid, end_vid, node, edge, cost, agg_cost)
  • pgr_aStar (One to One) added start_vid and end_vid columns.
  • pgr_aStar (One to Many) added end_vid column.
  • pgr_aStar (Many to One) added start_vid column.- #2523 Standarize output pgr_bdAstar
  • Standarizing output columns to (seq, path_seq, start_vid, end_vid, node, edge, cost, agg_cost)
  • pgr_bdAstar (One to One) added start_vid and end_vid columns.
  • pgr_bdAstar (One to Many) added end_vid column.
  • pgr_bdAstar (Many to One) added start_vid column.- #2547 Standarize output and modifying signature pgr_KSP
  • Result columns standarized to: (seq, path_id, path_seq, start_vid, end_vid, node, edge, cost, agg_cost)
  • pgr_ksp (One to One)
  • Added start_vid and end_vid result columns.- New overload functions:
  • pgr_ksp (One to Many)
  • pgr_ksp (Many to One)
  • pgr_ksp (Many to Many)
  • pgr_ksp (Combinations)- #2548 Standarize output pgr_drivingdistance
  • Standarizing output columns to (seq, depth, start_vid, pred, node, edge, cost, agg_cost)
  • pgr_drivingdistance (Single vertex)
  • Added depth and start_vid result columns.- pgr_drivingdistance (Multiple vertices)
  • Result column name change: from_v to start_vid.
  • Added depth and pred result columns.

Proposed functions changes

  • #2544 Standarize output and modifying signature pgr_withPointsDD
  • Signature change: driving_side parameter changed from named optional to unnamed compulsory driving side.
  • pgr_withPointsDD (Single vertex)
  • pgr_withPointsDD (Multiple vertices)- Standarizing output columns to (seq, depth, start_vid, pred, node, edge, cost, agg_cost)
  • pgr_withPointsDD (Single vertex)
  • Added depth, pred and start_vid column.- pgr_withPointsDD (Multiple vertices)
  • Added depth, pred columns.- When details is false:
  • Only points that are visited are removed, that is, points reached within the distance are included- Deprecated signatures
  • pgr_withpointsdd(text,text,bigint,double precision,boolean,character,boolean)
  • pgr_withpointsdd(text,text,anyarray,double precision,boolean,character,boolean,boolean)- #2546 Standarize output and modifying signature pgr_withPointsKSP
  • Standarizing output columns to (seq, path_id, path_seq, start_vid, end_vid, node, edge, cost, agg_cost)
  • pgr_withPointsKSP (One to One)
  • Signature change: driving_side parameter changed from named optional to unnamed compulsory driving side.
  • Added start_vid and end_vid result columns.- New overload functions
  • pgr_withPointsKSP (One to Many)
  • pgr_withPointsKSP (Many to One)
  • pgr_withPointsKSP (Many to Many)
  • pgr_withPointsKSP (Combinations)- Deprecated signature
  • pgr_withpointsksp(text,text,bigint,bigint,integer,boolean,boolean,char,boolean)

C/C++ code enhancements

  • #2504 To C++ pg data get, fetch and check.
  • Stopping support for compilation with MSVC.- #2505 Using namespace.
  • #2512 [Dijkstra] Removing duplicate code on Dijkstra.
  • #2517 Astar code simplification.
  • #2521 Dijkstra code simplification.
  • #2522 bdAstar code simplification.

Documentation

  • #2490 Automatic page history links.

SQL standarization

  • #2555 standarize deprecated messages
  • On new internal function: do not use named parameters and default parameters.

To update your database

Download the packaged version from your operating system, and use this command in the database:
ALTER EXTENSION pgrouting UPDATE TO “3.6.0”;

[1]. https://github.com/pgRouting/pgrouting/releases/latest

[2]. https://github.com/pgRouting/pgrouting/discussions/2587
[3]. https://github.com/pgRouting/pgrouting/issues?utf8=%E2%9C%93&q=milestone%3A%22Release%203.6.0%22

Regards,
pgRouting Team.