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.
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 .