v3.6.0

[krashish8]

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

---

This discussion was created from the release v3.6.0.

[krashish8]

What's Changed

• [CI] fixing centos test by @cvvergara in [CI] fixing centos test #2466
• Ci centos fix dev t1 by @cvvergara in Ci centos fix dev t1 #2467
• Ci centos fix dev t1 by @cvvergara in Ci centos fix dev t1 #2468
• Centos 7 self hosted test fix 3 (for Develop) by @robe2 in Centos 7 self hosted test fix 3 (for Develop) #2469
• Fix mingw64 compile (develop) by @robe2 in Fix mingw64 compile (develop) #2480
• added postgres 15 as dependency by @aryan1010 in added postgres 15 as dependency #2460
• Translations update from OSGeo Weblate by @osgeoweblate in Translations update from OSGeo Weblate #2457
• Pumpup to 3.6.0 by @cvvergara in Pumpup to 3.6.0 #2485
• [locale] fix error on locale files by @cvvergara in [locale] fix error on locale files #2486
• Translations update from OSGeo Weblate by @osgeoweblate in Translations update from OSGeo Weblate #2487
• Automatic page history links porting from 2489 by @cvvergara in Automatic page history links porting from 2489 #2490
• Port changes in main by @cvvergara in Port changes in main #2499
• Translations update from OSGeo Weblate by @osgeoweblate in Translations update from OSGeo Weblate #2491
• Using namespace dev by @cvvergara in Using namespace dev #2505
• Translations update from OSGeo Weblate by @osgeoweblate in Translations update from OSGeo Weblate #2506
• To C++ pg data get, fetch and check by @cvvergara in To C++ pg data get, fetch and check #2504
• Translations update from OSGeo Weblate by @osgeoweblate in Translations update from OSGeo Weblate #2510
• Fix winnie build (Fix winnie build #2514) - develop branch by @robe2 in Fix winnie build (#2514) - develop branch #2515
• [dijkstra] Removing duplicated code by @cvvergara in [dijkstra] Removing duplicated code #2512
• Standarize output astar by @cvvergara in Standarize output astar #2516
• Astar code simplification by @cvvergara in Astar code simplification #2517
• Porting degree doc changes to develop by @cvvergara in Degree doc changes to develop #2520
• Dijkstra code simplification by @cvvergara in Dijkstra code simplification #2521
• bdAstar code simplification by @cvvergara in bdAstar code simplification #2522
• Bd astar output standarization by @cvvergara in Bd astar output standarization #2523
• Docqueries fix by @cvvergara in Docqueries fix #2524
• Fix for pg16. Closes pgRouting develop doesn't compile against PG16 #2525 by @robe2 in Fix for pg16. Closes #2525 #2526
• Update flow-family.rst fix typo by @robe2 in Update flow-family.rst fix typo #2531
• Fixing codacy issues by @cvvergara in Fixing codacy issues #2532
• Robe2 master to main develop by @robe2 in Robe2 master to main develop #2533
• [update] fixing script for database update by @cvvergara in [update] fixing script for database update #2538
• Fix migration doc of bdAstar by @cvvergara in Fix migration doc of bdAstar #2540
• [drivingdistance] Cleaning up C++ code by @aryan1010 in [drivingdistance] Cleaning up C++ code #2542
• [GSoC-2023] Modifying - withpointsdd by @squarege in [GSoC-2023] Modifying - withpointsdd #2544
• [GSoC-2023] Modifying - withpointsdd - supplement by @squarege in [GSoC-2023] Modifying - withpointsdd - supplement  #2545
• [GSoC 2023] Modifying withPointsKSP by @AbhinJ in [GSoC 2023] Modifying withPointsKSP #2546
• [GSoC 2023] Modifying KSP by @Aniket-debug in [GSoC 2023] Modifying KSP #2547
• [GSoC 2023] Modifying drivingdistance by @aryan1010 in [GSoC 2023] Modifying drivingdistance #2548
• Fix documentation by @cvvergara in Fix documentation #2549
• Cleaningcode by @aryan1010 in Cleaningcode #2551
• Driving distance with and without points simplify code by @cvvergara in Driving distance with and without points simplify code #2552
• Bump actions/checkout from 3 to 4 by @cvvergara in Bump actions/checkout from 3 to 4 #2554
• Standardize deprecated messages by @cvvergara in Standardize deprecated messages #2555
• Porting use sampledata from main by @cvvergara in Porting use sampledata from main #2560
• Port changes from 3.5.1 to 3.6.0 by @cvvergara in Port changes from 3.5.1 to 3.6.0 #2567
• Update centos.yml by @cvvergara in Update centos.yml #2568
• Add predecessor column dd and withpoints dd by @cvvergara in Add predecessor column dd and withpoints dd #2570
• Clean up pgr_ksp pgr_withPointsKSP by @cvvergara in Clean up pgr_ksp pgr_withPointsKSP #2572
• Doc double space removal by @cvvergara in Doc double space removal #2576
• Fixing doc non standard phrases by @cvvergara in Fixing doc non standard phrases #2577
• Doc fixes by @cvvergara in Doc fixes #2578
• Translations update from OSGeo Weblate by @osgeoweblate in Translations update from OSGeo Weblate #2511
• Develop by @cvvergara in Develop Prepares next minor release. #2579
• Pre release 3.6 by @cvvergara in Pre release 3.6 #2580
• [actions] Fix postgres version regex - cherrypick to main by @krashish8 in [actions] Fix postgres version regex - cherrypick to main #2585

New Contributors

• @squarege made their first contribution in [GSoC-2023] Modifying - withpointsdd #2544
• @AbhinJ made their first contribution in [GSoC 2023] Modifying withPointsKSP #2546

Full Changelog: v3.5.1...v3.6.0