I have a postgres database with the postgis extension enabled in the public schema. We have put the public schema in the search path, but still can only get the postgis function (i.e. st_x() ) if we explicitly refer to the public schema, but we get:
select st_x(obspoint_geom) from sc2.observation_points; ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. ********** Error **********
ERROR: function st_x(public.geometry) does not exist SQL state: 42883 Hint: No function matches the given name and argument types. You might need to add explicit type casts. Character: 8
Any idea what is happening?
select st_x(st_makepoint(0.0,1.0))
. If that works, the problem might be the type of your obspoint_geom column