v3.7.0

pgRouting 3.7.0 Release Notes

To see all issues & pull requests closed by this release see the Git closed milestone for 3.7.0

Support

• #2656 Stop support of PostgreSQL12 on pgrouting v3.7

  • Stopping support of PostgreSQL 12
  • CI does not test for PostgreSQL 12

New experimental functions

• Metrics

  • pgr_betweennessCentrality

Official functions changes

• #2605 Standarize spanning tree functions output

  • Functions:

    • pgr_kruskalDD
    • pgr_kruskalDFS
    • pgr_kruskalBFS
    • pgr_primDD
    • pgr_primDFS
    • pgr_primBFS

  • Standarizing output columns to (seq, depth, start_vid, pred, node, edge, cost, agg_cost)

    • Added pred result columns.

Experimental promoted to proposed.

• #2635 pgr_LineGraph ignores directed flag and use negative values for identifiers.

  • pgr_lineGraph

    • Promoted to proposed signature.
    • Works for directed and undirected graphs.

Code enhancement

• #2599 Driving distance cleanup
• #2607 Read postgresql data on C++
• #2614 Clang tidy does not work

Attachments

File	Contents
doc-v3.7.0.tar.gz	English, Chinese and Spanish documentation. Redirection to English
pgrouting-3.7.0.tar.gz	tar.gz of the release
pgrouting-3.7.0.zip	zip of the release

v3.6.3

pgRouting 3.6.3 Release Notes

To see all issues & pull requests closed by this release see the Git closed milestone for 3.6.3

Build

• Explicit minimum requirements:

  • postgres 11.0.0
  • postgis 3.0.0

• g++ 13+ is supported

Code fixes

• Fix warnings from cpplint.
• Fix warnings from clang 18.

CI tests

• Add a clang tidy test on changed files.
• Update test not done on versions: 3.0.1, 3.0.2, 3.0.3, 3.0.4, 3.1.0, 3.1.1, 3.1.2

Documentation

• Results of documentation queries adujsted to boost 1.83.0 version:

  • pgr_edgeDisjointPaths
  • pgr_stoerWagner

pgtap tests

• bug fixes

Attachments

File	Contents
doc-v3.6.3.tar.gz	English, Spanish & Simplified Chinese documentation. Redirection to English
pgrouting-3.6.3.tar.gz	tar.gz of the release
pgrouting-3.6.3.zip	zip of the release

v3.6.2

pgRouting 3.6.2 Release Notes

To see all issues & pull requests closed by this release see the Git closed milestone for 3.6.2

Upgrade fix

• The upgrade was failing for same minor

Code fixes

• Fix warnings from cpplint

Others

• Adjust NEWS generator
  • Name change to NEWS.md for better visualization on GitHub

Attachments

File	Contents
doc-v3.6.2-en-es.tar.gz	English and Spanish documentation. Redirection to English
doc-v3.6.2-en.tar.gz	English documentation. Redirection to English
doc-v3.6.2-es.tar.gz	Spanish documentation. Redirection to Spanish
pgrouting-3.6.2.tar.gz	tar.gz of the release
pgrouting-3.6.2.zip	zip of the release

v3.6.1

pgRouting 3.6.1 Release Notes

To see all issues & pull requests closed by this release see the Git closed milestone for 3.6.1

Issue fixes

• #2588 pgrouting 3.6.0 fails to build on OSX

Attachments

File	Contents
doc-v3.6.1-en-es.tar.gz	English and Spanish documentation. Redirection to English
doc-v3.6.1-en.tar.gz	English documentation. Redirection to English
doc-v3.6.1-es.tar.gz	Spanish documentation. Redirection to Spanish
pgrouting-3.6.1.tar.gz	tar.gz of the release
pgrouting-3.6.1.zip	zip of the release

v3.6.0

pgRouting 3.6.0 Release Notes

To see all issues & pull requests closed by this release see the Git closed milestone for 3.6.0

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.

Attachments

File	Contents
doc-v3.6.0-en-es.tar.gz	English and Spanish documentation. Redirection to English
doc-v3.6.0-en.tar.gz	English documentation. Redirection to English
doc-v3.6.0-es.tar.gz	Spanish documentation. Redirection to Spanish
pgrouting-3.6.0.tar.gz	tar.gz of the release
pgrouting-3.6.0.zip	zip of the release

v3.5.1

pgRouting 3.5.1 Release Notes

To see all issues & pull requests closed by this release see the Git closed milestone for 3.5.1

Documentation fixes

Changes on the documentation to the following:

• pgr_degree
• pgr_dijkstra
• pgr_ksp
• Automatic page history links
  • using bootstrap_version 2 because 3+ does not do dropdowns

Issue fixes

• #2565: pgr_pgr_lengauerTarjanDominatorTree triggers an assertion

SQL enhancements

• #2561: Not use wildcards on SQL

pgtap tests

• #2559: pgtap test using sampledata

Build fixes

• Fix winnie build

Code fixes

• Fix clang warnings

  • Grouping headers of postgres readers

Attachments

File	Contents
doc-v3.5.1-en-es.tar.gz	English and Spanish documentation. Redirection to English
doc-v3.5.1-en.tar.gz	English documentation. Redirection to English
doc-v3.5.1-es.tar.gz	Spanish documentation. Redirection to Spanish
pgrouting-3.5.1.tar.gz	tar.gz of the release
pgrouting-3.5.1.zip	zip of the release

v3.5.0

pgRouting 3.5.0 Release Notes

To see all issues & pull requests closed by this release see the Git closed milestone for 3.5.0

Official functions changes

• Dijkstra

  • Standarizing output columns to |short-generic-result|

    • pgr_dijkstra (One to One) added start_vid and end_vid columns.
    • pgr_dijkstra (One to Many) added end_vid column.
    • pgr_dijkstra (Many to One) added start_vid column.

Attachments

File	Contents
doc-v3.5.0-en-es.tar.gz	English and Spanish documentation. Redirection to English
doc-v3.5.0-en.tar.gz	English documentation. Redirection to English
doc-v3.5.0-es.tar.gz	Spanish documentation. Redirection to Spanish
pgrouting-3.5.0.tar.gz	tar.gz of the release
pgrouting-3.5.0.zip	zip of the release

v3.4.2

pgRouting 3.4.2 Release Notes

To see all issues & pull requests closed by this release see the Git closed milestone for 3.4.2

Issue fixes

• #2394: pgr_bdAstar accumulates heuristic cost in visited node cost.
• #2427: pgr_createVerticesTable & pgr_createTopology, variable should be of type Record.

Attachments

File	Contents
doc-v3.4.2-en-es.tar.gz	English and Spanish documentation. Redirection to English
doc-v3.4.2-en.tar.gz	English documentation. Redirection to English
doc-v3.4.2-es.tar.gz	Spanish documentation. Redirection to Spanish
pgrouting-3.4.2.tar.gz	tar.gz of the release
pgrouting-3.4.2.zip	zip of the release

v3.4.1

pgRouting 3.4.1 Release Notes

To see all issues & pull requests closed by this release see the Git closed milestone for 3.4.1

Issue fixes

• #2401: pgRouting 3.4.0 do not build docs when sphinx is too low or missing
• #2398: v3.4.0 does not upgrade from 3.3.3

v3.3.5

pgRouting 3.3.5 Release Notes

To see all issues & pull requests closed by this release see the Git closed milestone for 3.3.5

• #2401: pgRouting 3.4.0 do not build docs when sphinx is too low or missing