Hello
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.
pending your greetings.
Le mar. 10 août 2021 à 20:00, <pgrouting-users-request@lists.osgeo.org> a écrit :
Send Pgrouting-users mailing list submissions to
pgrouting-users@lists.osgeo.orgTo subscribe or unsubscribe via the World Wide Web, visit
https://lists.osgeo.org/mailman/listinfo/pgrouting-users
or, via email, send a message with subject or body ‘help’ to
pgrouting-users-request@lists.osgeo.orgYou can reach the person managing the list at
pgrouting-users-owner@lists.osgeo.orgWhen replying, please edit your Subject line so it is more specific
than “Re: Contents of Pgrouting-users digest…”Today’s Topics:
- Re: Pgrouting-users Digest, Vol 137, Issue 1 (Daniel Kastl)
Message: 1
Date: Tue, 10 Aug 2021 09:15:53 +0900
From: Daniel Kastl <daniel@georepublic.de>
To: pgRouting users mailing list <pgrouting-users@lists.osgeo.org>
Subject: Re: [pgrouting-users] Pgrouting-users Digest, Vol 137, Issue
1
Message-ID:
<CABXBSH9qU33gFXCZUdGAreSi46rBRFMEOERFDp61HTRJMTYFzA@mail.gmail.com>
Content-Type: text/plain; charset=“utf-8”In PostgreSQL you can organize your tables, functions and others in
SCHEMA’s.
Eventually your so-called “search_path” is not set correctly and you are
using a different schema than the default “public”.Can you run the following commands and post the result here?
SELECT version();
SELECT postgis_full_version();
SELECT pgr_version();Best regards,
DanielOn Tue, 10 Aug 2021 at 04:39, Boubacar Bah <bahbouba.909@gmail.com> wrote:
hello ; l verified my database pgrouting is install and all the function
is load but l don’t know why it not working. this is the error
message down
on the left of the image we can see the function list and l see the
pgr_dijkstra function but it’s don’t work
waiting your response
thank in advanceLe lun. 9 ao?t 2021 ? 20:01, <pgrouting-users-request@lists.osgeo.org> a
?crit :Send Pgrouting-users mailing list submissions to
pgrouting-users@lists.osgeo.orgTo subscribe or unsubscribe via the World Wide Web, visit
https://lists.osgeo.org/mailman/listinfo/pgrouting-users
or, via email, send a message with subject or body ‘help’ to
pgrouting-users-request@lists.osgeo.orgYou can reach the person managing the list at
pgrouting-users-owner@lists.osgeo.orgWhen replying, please edit your Subject line so it is more specific
than “Re: Contents of Pgrouting-users digest…”Today’s Topics:
- Asking help (Boubacar Bah)
- Re: Asking help (Rajat Shinde)
Message: 1
Date: Mon, 9 Aug 2021 14:24:55 +0100
From: Boubacar Bah <bahbouba.909@gmail.com>
To: pgrouting-users@lists.osgeo.org
Subject: [pgrouting-users] Asking help
Message-ID:
<
CALOg8kGhEwenrGrZ-e8XihFJ9Ycb-kjUx3x0TKf59gdARghpYw@mail.gmail.com>
Content-Type: text/plain; charset=“utf-8”Hello.I m New in postgresql so l try to use the pgrouting functions in my
database which have postgis and pgrouting extension but they show me an
error saying the function of pgrouting doesn’t exist. So l please you to
explain me how l can load the pgrouting function in my database . My
exploitation system is window 10 and postgresql 12
Waiting your response
cordial receive my salutations
-------------- next part --------------
An HTML attachment was scrubbed…
URL: <
http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210809/c3f3d89a/attachment-0001.html
Message: 2
Date: Mon, 9 Aug 2021 19:16:10 +0530
From: Rajat Shinde <rajatshinde2303@gmail.com>
To: pgRouting users mailing list <pgrouting-users@lists.osgeo.org>
Subject: Re: [pgrouting-users] Asking help
Message-ID:
<
CAKyj99mMamWJCoeWx45cHCMnBGNpXVNEYsF1QiN-nJCUUqpuSQ@mail.gmail.com>
Content-Type: text/plain; charset=“utf-8”Hi,
It’s hard to say anything without seeing the error messages but I think it
is probably because pgRouting is not installed (See this:
https://workshop.pgrouting.org/2.6/en/chapters/installation.html). It
will
be great if you could send an screenshot of the error or share the error
logs.Also, please find the pgRouting workshop (
https://workshop.pgrouting.org/2.6/en/index.html). It contains chapters
on
setting up and getting started with the pgRouting algorithms.Best,
RajatOn Mon, Aug 9, 2021 at 6:55 PM Boubacar Bah <bahbouba.909@gmail.com>
wrote:Hello.I m New in postgresql so l try to use the pgrouting functions in
my
database which have postgis and pgrouting extension but they show me an
error saying the function of pgrouting doesn’t exist. So l please you to
explain me how l can load the pgrouting function in my database . My
exploitation system is window 10 and postgresql 12
Waiting your response
cordial receive my salutations
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/pgrouting-users-------------- next part --------------
An HTML attachment was scrubbed…
URL: <
http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210809/f464de94/attachment-0001.html
Subject: Digest Footer
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/pgrouting-users
End of Pgrouting-users Digest, Vol 137, Issue 1
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/pgrouting-users–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: https://georepublic.info
-------------- next part --------------
An HTML attachment was scrubbed…
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210810/352e44d9/attachment-0001.html>
Subject: Digest Footer
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/pgrouting-users
End of Pgrouting-users Digest, Vol 137, Issue 3