<div dir="ltr">good evening daniel indeed the problem was due to my data because i tried on the data from the link you sent me and the pgr_djikstra function worked. but what I don't understand is that my data comes from open street may that I downloaded from the geofabrik site. here is the file of my data in question Please can someone check this data to tell me the causes which make the function pgr_dikstra not work on this data<br>thanks in advance<br><div><div class="gmail_chip gmail_drive_chip" style="width:396px;height:18px;max-height:18px;background-color:rgb(245,245,245);padding:5px;font-family:arial;font-weight:bold;font-size:13px;border:1px solid rgb(221,221,221);line-height:1"><a href="https://drive.google.com/file/d/1Z0c054zwcse_a43-PwHGV1pPgDeJem-X/view?usp=drive_web" target="_blank" style="display:inline-block;max-width:366px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;text-decoration-line:none;padding:1px 0px;border:none" aria-label="midi-pyrenees-latest-free.shp.zip"><img style="vertical-align: bottom; border: none;" src="https://ssl.gstatic.com/docs/doclist/images/icon_10_generic_list.png"> <span dir="ltr" style="vertical-align:bottom;text-decoration:none">midi-pyrenees-latest-free.shp.zip</span></a><img src="//ssl.gstatic.com/ui/v1/icons/common/x_8px.png" style="opacity: 0.55; cursor: pointer; float: right; position: relative; top: -1px; display: none;"></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le mer. 11 août 2021 à 20:04, <<a href="mailto:pgrouting-users-request@lists.osgeo.org">pgrouting-users-request@lists.osgeo.org</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Send Pgrouting-users mailing list submissions to<br>
<a href="mailto:pgrouting-users@lists.osgeo.org" target="_blank">pgrouting-users@lists.osgeo.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:pgrouting-users-request@lists.osgeo.org" target="_blank">pgrouting-users-request@lists.osgeo.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:pgrouting-users-owner@lists.osgeo.org" target="_blank">pgrouting-users-owner@lists.osgeo.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Pgrouting-users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: Pgrouting-users Digest, Vol 137, Issue 3 (Daniel Kastl)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Wed, 11 Aug 2021 09:39:28 +0900<br>
From: Daniel Kastl <<a href="mailto:daniel@georepublic.de" target="_blank">daniel@georepublic.de</a>><br>
To: pgRouting users mailing list <<a href="mailto:pgrouting-users@lists.osgeo.org" target="_blank">pgrouting-users@lists.osgeo.org</a>><br>
Subject: Re: [pgrouting-users] Pgrouting-users Digest, Vol 137, Issue<br>
3<br>
Message-ID:<br>
<<a href="mailto:CABXBSH-SSnOoUZ8D9bh_LWQrnnNyO71bc1BsK_zc6SQqL9nKxg@mail.gmail.com" target="_blank">CABXBSH-SSnOoUZ8D9bh_LWQrnnNyO71bc1BsK_zc6SQqL9nKxg@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Thanks for sending the version information.<br>
It seems you are using a beta version of PostGIS 3.2, which I'm not sure we<br>
are testing this version with pgRouting already.<br>
But it shouldn't be the problem.<br>
<br>
I guess there is something wrong in your custom database setup.<br>
It would be good to try to test step by step to see where it stops working.<br>
<br>
There is a pgRouting workshop, but it's not written for Windows.<br>
You can use it on your Windows installation, but I would suggest to try the<br>
sample data from the pgRouting documentation.<br>
<br>
1. Create a new database<br>
2. Install extensions PostGIS and pgRouting<br>
3. Load the sample network<br>
<a href="https://docs.pgrouting.org/latest/en/sampledata.html" rel="noreferrer" target="_blank">https://docs.pgrouting.org/latest/en/sampledata.html</a><br>
4. Test the pg_dijkstra function example from the documentation for<br>
example <a href="https://docs.pgrouting.org/latest/en/pgr_dijkstra.html" rel="noreferrer" target="_blank">https://docs.pgrouting.org/latest/en/pgr_dijkstra.html</a><br>
<br>
If you get to that point, then the problem occurs with your data (loading)<br>
and is not related to pgRouting.<br>
<br>
Best regards,<br>
Daniel<br>
<br>
<br>
<br>
<br>
On Wed, 11 Aug 2021 at 06:39, Boubacar Bah <<a href="mailto:bahbouba.909@gmail.com" target="_blank">bahbouba.909@gmail.com</a>> wrote:<br>
<br>
> Hello<br>
> effectively daniel i use a different public shema but I had changed the<br>
> search_path to this shema in question but pgrouting did not work after I<br>
> import my tables to the public shema I then change the search_path to the<br>
> shema the pg_dijkstra query still didn't work but the pgr_createtopology<br>
> query works apart from this function none of the others in pgrouting work.<br>
> here is the result of the queries you requested.<br>
> pending your greetings.<br>
><br>
> Le mar. 10 ao?t 2021 ? 20:00, <<a href="mailto:pgrouting-users-request@lists.osgeo.org" target="_blank">pgrouting-users-request@lists.osgeo.org</a>> a<br>
> ?crit :<br>
><br>
>> Send Pgrouting-users mailing list submissions to<br>
>> <a href="mailto:pgrouting-users@lists.osgeo.org" target="_blank">pgrouting-users@lists.osgeo.org</a><br>
>><br>
>> To subscribe or unsubscribe via the World Wide Web, visit<br>
>> <a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
>> or, via email, send a message with subject or body 'help' to<br>
>> <a href="mailto:pgrouting-users-request@lists.osgeo.org" target="_blank">pgrouting-users-request@lists.osgeo.org</a><br>
>><br>
>> You can reach the person managing the list at<br>
>> <a href="mailto:pgrouting-users-owner@lists.osgeo.org" target="_blank">pgrouting-users-owner@lists.osgeo.org</a><br>
>><br>
>> When replying, please edit your Subject line so it is more specific<br>
>> than "Re: Contents of Pgrouting-users digest..."<br>
>><br>
>><br>
>> Today's Topics:<br>
>><br>
>> 1. Re: Pgrouting-users Digest, Vol 137, Issue 1 (Daniel Kastl)<br>
>><br>
>><br>
>> ----------------------------------------------------------------------<br>
>><br>
>> Message: 1<br>
>> Date: Tue, 10 Aug 2021 09:15:53 +0900<br>
>> From: Daniel Kastl <<a href="mailto:daniel@georepublic.de" target="_blank">daniel@georepublic.de</a>><br>
>> To: pgRouting users mailing list <<a href="mailto:pgrouting-users@lists.osgeo.org" target="_blank">pgrouting-users@lists.osgeo.org</a>><br>
>> Subject: Re: [pgrouting-users] Pgrouting-users Digest, Vol 137, Issue<br>
>> 1<br>
>> Message-ID:<br>
>> <<br>
>> <a href="mailto:CABXBSH9qU33gFXCZUdGAreSi46rBRFMEOERFDp61HTRJMTYFzA@mail.gmail.com" target="_blank">CABXBSH9qU33gFXCZUdGAreSi46rBRFMEOERFDp61HTRJMTYFzA@mail.gmail.com</a>><br>
>> Content-Type: text/plain; charset="utf-8"<br>
>><br>
>> In PostgreSQL you can organize your tables, functions and others in<br>
>> SCHEMA's.<br>
>> Eventually your so-called "search_path" is not set correctly and you are<br>
>> using a different schema than the default "public".<br>
>><br>
>> Can you run the following commands and post the result here?<br>
>><br>
>> SELECT version();<br>
>> SELECT postgis_full_version();<br>
>> SELECT pgr_version();<br>
>><br>
>> Best regards,<br>
>> Daniel<br>
>><br>
>> On Tue, 10 Aug 2021 at 04:39, Boubacar Bah <<a href="mailto:bahbouba.909@gmail.com" target="_blank">bahbouba.909@gmail.com</a>><br>
>> wrote:<br>
>><br>
>> > hello ; l verified my database pgrouting is install and all the function<br>
>> > is load but l don't know why it not working. this is the error<br>
>> > message down<br>
>> > on the left of the image we can see the function list and l see the<br>
>> > pgr_dijkstra function but it's don't work<br>
>> > waiting your response<br>
>> > thank in advance<br>
>> ><br>
>> > Le lun. 9 ao?t 2021 ? 20:01, <<a href="mailto:pgrouting-users-request@lists.osgeo.org" target="_blank">pgrouting-users-request@lists.osgeo.org</a>><br>
>> a<br>
>> > ?crit :<br>
>> ><br>
>> >> Send Pgrouting-users mailing list submissions to<br>
>> >> <a href="mailto:pgrouting-users@lists.osgeo.org" target="_blank">pgrouting-users@lists.osgeo.org</a><br>
>> >><br>
>> >> To subscribe or unsubscribe via the World Wide Web, visit<br>
>> >> <a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
>> >> or, via email, send a message with subject or body 'help' to<br>
>> >> <a href="mailto:pgrouting-users-request@lists.osgeo.org" target="_blank">pgrouting-users-request@lists.osgeo.org</a><br>
>> >><br>
>> >> You can reach the person managing the list at<br>
>> >> <a href="mailto:pgrouting-users-owner@lists.osgeo.org" target="_blank">pgrouting-users-owner@lists.osgeo.org</a><br>
>> >><br>
>> >> When replying, please edit your Subject line so it is more specific<br>
>> >> than "Re: Contents of Pgrouting-users digest..."<br>
>> >><br>
>> >><br>
>> >> Today's Topics:<br>
>> >><br>
>> >> 1. Asking help (Boubacar Bah)<br>
>> >> 2. Re: Asking help (Rajat Shinde)<br>
>> >><br>
>> >><br>
>> >> ----------------------------------------------------------------------<br>
>> >><br>
>> >> Message: 1<br>
>> >> Date: Mon, 9 Aug 2021 14:24:55 +0100<br>
>> >> From: Boubacar Bah <<a href="mailto:bahbouba.909@gmail.com" target="_blank">bahbouba.909@gmail.com</a>><br>
>> >> To: <a href="mailto:pgrouting-users@lists.osgeo.org" target="_blank">pgrouting-users@lists.osgeo.org</a><br>
>> >> Subject: [pgrouting-users] Asking help<br>
>> >> Message-ID:<br>
>> >> <<br>
>> >> <a href="mailto:CALOg8kGhEwenrGrZ-e8XihFJ9Ycb-kjUx3x0TKf59gdARghpYw@mail.gmail.com" target="_blank">CALOg8kGhEwenrGrZ-e8XihFJ9Ycb-kjUx3x0TKf59gdARghpYw@mail.gmail.com</a>><br>
>> >> Content-Type: text/plain; charset="utf-8"<br>
>> >><br>
>> >> Hello.I m New in postgresql so l try to use the pgrouting functions in<br>
>> my<br>
>> >> database which have postgis and pgrouting extension but they show me an<br>
>> >> error saying the function of pgrouting doesn't exist. So l please you<br>
>> to<br>
>> >> explain me how l can load the pgrouting function in my database . My<br>
>> >> exploitation system is window 10 and postgresql 12<br>
>> >> Waiting your response<br>
>> >> cordial receive my salutations<br>
>> >> -------------- next part --------------<br>
>> >> An HTML attachment was scrubbed...<br>
>> >> URL: <<br>
>> >><br>
>> <a href="http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210809/c3f3d89a/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210809/c3f3d89a/attachment-0001.html</a><br>
>> >> ><br>
>> >><br>
>> >> ------------------------------<br>
>> >><br>
>> >> Message: 2<br>
>> >> Date: Mon, 9 Aug 2021 19:16:10 +0530<br>
>> >> From: Rajat Shinde <<a href="mailto:rajatshinde2303@gmail.com" target="_blank">rajatshinde2303@gmail.com</a>><br>
>> >> To: pgRouting users mailing list <<a href="mailto:pgrouting-users@lists.osgeo.org" target="_blank">pgrouting-users@lists.osgeo.org</a>><br>
>> >> Subject: Re: [pgrouting-users] Asking help<br>
>> >> Message-ID:<br>
>> >> <<br>
>> >> <a href="mailto:CAKyj99mMamWJCoeWx45cHCMnBGNpXVNEYsF1QiN-nJCUUqpuSQ@mail.gmail.com" target="_blank">CAKyj99mMamWJCoeWx45cHCMnBGNpXVNEYsF1QiN-nJCUUqpuSQ@mail.gmail.com</a>><br>
>> >> Content-Type: text/plain; charset="utf-8"<br>
>> >><br>
>> >> Hi,<br>
>> >><br>
>> >> It's hard to say anything without seeing the error messages but I<br>
>> think it<br>
>> >> is probably because pgRouting is not installed (See this:<br>
>> >> <a href="https://workshop.pgrouting.org/2.6/en/chapters/installation.html" rel="noreferrer" target="_blank">https://workshop.pgrouting.org/2.6/en/chapters/installation.html</a>). It<br>
>> >> will<br>
>> >> be great if you could send an screenshot of the error or share the<br>
>> error<br>
>> >> logs.<br>
>> >><br>
>> >> Also, please find the pgRouting workshop (<br>
>> >> <a href="https://workshop.pgrouting.org/2.6/en/index.html" rel="noreferrer" target="_blank">https://workshop.pgrouting.org/2.6/en/index.html</a>). It contains<br>
>> chapters<br>
>> >> on<br>
>> >> setting up and getting started with the pgRouting algorithms.<br>
>> >><br>
>> >> Best,<br>
>> >> Rajat<br>
>> >><br>
>> >> On Mon, Aug 9, 2021 at 6:55 PM Boubacar Bah <<a href="mailto:bahbouba.909@gmail.com" target="_blank">bahbouba.909@gmail.com</a>><br>
>> >> wrote:<br>
>> >><br>
>> >> ><br>
>> >> > Hello.I m New in postgresql so l try to use the pgrouting functions<br>
>> in<br>
>> >> my<br>
>> >> > database which have postgis and pgrouting extension but they show me<br>
>> an<br>
>> >> > error saying the function of pgrouting doesn't exist. So l please<br>
>> you to<br>
>> >> > explain me how l can load the pgrouting function in my database . My<br>
>> >> > exploitation system is window 10 and postgresql 12<br>
>> >> > Waiting your response<br>
>> >> > cordial receive my salutations<br>
>> >> ><br>
>> >> > _______________________________________________<br>
>> >> > Pgrouting-users mailing list<br>
>> >> > <a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
>> >> > <a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
>> >> ><br>
>> >> -------------- next part --------------<br>
>> >> An HTML attachment was scrubbed...<br>
>> >> URL: <<br>
>> >><br>
>> <a href="http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210809/f464de94/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210809/f464de94/attachment-0001.html</a><br>
>> >> ><br>
>> >><br>
>> >> ------------------------------<br>
>> >><br>
>> >> Subject: Digest Footer<br>
>> >><br>
>> >> _______________________________________________<br>
>> >> Pgrouting-users mailing list<br>
>> >> <a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
>> >> <a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
>> >><br>
>> >><br>
>> >> ------------------------------<br>
>> >><br>
>> >> End of Pgrouting-users Digest, Vol 137, Issue 1<br>
>> >> ***********************************************<br>
>> >><br>
>> > _______________________________________________<br>
>> > Pgrouting-users mailing list<br>
>> > <a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
>> > <a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
>> ><br>
>><br>
>><br>
>> --<br>
>> Georepublic UG & Georepublic Japan<br>
>> eMail: <a href="mailto:daniel.kastl@georepublic.de" target="_blank">daniel.kastl@georepublic.de</a><br>
>> Web: <a href="https://georepublic.info" rel="noreferrer" target="_blank">https://georepublic.info</a><br>
>> -------------- next part --------------<br>
>> An HTML attachment was scrubbed...<br>
>> URL: <<br>
>> <a href="http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210810/352e44d9/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210810/352e44d9/attachment-0001.html</a><br>
>> ><br>
>><br>
>> ------------------------------<br>
>><br>
>> Subject: Digest Footer<br>
>><br>
>> _______________________________________________<br>
>> Pgrouting-users mailing list<br>
>> <a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
>> <a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
>><br>
>><br>
>> ------------------------------<br>
>><br>
>> End of Pgrouting-users Digest, Vol 137, Issue 3<br>
>> ***********************************************<br>
>><br>
> _______________________________________________<br>
> Pgrouting-users mailing list<br>
> <a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
> <a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
><br>
<br>
<br>
-- <br>
Georepublic UG & Georepublic Japan<br>
eMail: <a href="mailto:daniel.kastl@georepublic.de" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="https://georepublic.info" rel="noreferrer" target="_blank">https://georepublic.info</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210811/f08bcbb4/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210811/f08bcbb4/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br>
<br>
------------------------------<br>
<br>
End of Pgrouting-users Digest, Vol 137, Issue 5<br>
***********************************************<br>
</blockquote></div>