<div dir="ltr">Hello<br>effectively daniel i use a different public shema but I had changed the search_path to this shema in question but pgrouting did not work after I import my tables to the public shema I then change the search_path to the shema the pg_dijkstra query still didn't work but the pgr_createtopology query works apart from this function none of the others in pgrouting work. here is the result of the queries you requested.<br>pending your greetings.<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le mar. 10 août 2021 à 20:00, <<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 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>
<<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>> 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>> 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 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 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>
>> <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 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 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 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 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 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>
>> <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: <<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>
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>
</blockquote></div>