I've built a query which uses ST_asGeoJSON(); and If I run it on my server through pgadmin with credentials of UserX it runs like a charm.
But when connecting through an webapp with other credentialsof UserY it returns me the following error:
SQLSTATE: Undefined function: 7 ERROR: function st_asgeojson(public.geometry) does not exist LINE 17: ,ST_AsGeoJSON(vbo.geopunt) AS vbo_geopunt ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
So I tried to explicitly cast to
::point but then It still does not work.
If I connect my webapp with the working credentials of UserX it also produces the same error.
Any idea what I'm missing?