0

hellow, I'm learning to create a routing application with this new workshop. This is using Postgres as the database, and its extensions PostGIS and pgRouting. It uses GeoServer to manage data and publish that.

I got data from osm and then added it to database with osm2pgrouting to be able to use them. After that I installed geoserver too then created a layer for my data but when I try to create new SQL view I get this error:

ERROR: function wrk_fromatob(unknown, integer, integer, integer, integer) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 76

I searched a lot but I can't find any answer.

Mahdi Nazari Ashani
  • 372
  • 1
  • 5
  • 22
  • The function could be in a schema that is not in your current `search_path`. You could be connected to a different database. You could be connected as a user that does not have permissions on the function or the schema that contains it. – Laurenz Albe Jul 19 '17 at 07:45
  • thanks so much, I found out that i forgot a function to add to database. i will post answer for my question soon – Mahdi Nazari Ashani Jul 19 '17 at 10:28

1 Answers1

0

I forgot to create wrk_fromatob() function in my database. so there is the answer on this part of workshop: Writing a pl/pgsql Stored Procedures .

Mahdi Nazari Ashani
  • 372
  • 1
  • 5
  • 22