pgRouting / pgrouting

Repository contains pgRouting library. Development branch is "develop", stable branch is "master"
https://pgrouting.org
GNU General Public License v2.0
1.16k stars 366 forks source link

Bug(?) with pgr_createVerticesTable and pgr_createtopology functions (v3.4+) #2427

Closed Nick-Nal closed 1 year ago

Nick-Nal commented 1 year ago

Greetings.

Problem Functions pgr_createVerticesTable and pgr_createtopology does not working properly in PGR 3.4.0 and 3.4.1 because of this:

DECLARE dummyRec TEXT; ... sql = 'SELECT * FROM '||_pgr_quote_ident(tabname)||' WHERE true'||rows_where ||' limit 1'; EXECUTE sql INTO dummyRec;

Obviously, this variable should be of type Record. Currently this problem blocks initial checks on tables when using these two functions, because it generates exception. AFAIR, this bug wasn't present in 3.3.x versions earlier this year.

cvvergara commented 1 year ago

Thanks for reporting, will fix soon, on 3.4.2, but that micro will be released in 15 days aprox

Nick-Nal commented 1 year ago

Thank you