PREPARE get_way (int4) AS SELECT AsText(way) FROM planet_osm_point WHERE osm_id
= $1;
failed: ERROR: function astext(geometry) does not exist
LINE 1: PREPARE get_way (int4) AS SELECT AsText(way) FROM planet_osm...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Any ideas? I’ve never used Postgres or osm2pgsql before.
Seems to be the same issue than with the current Mapserver and Postgis 2.0. Postgis 2.0 renames some functions to more standard ones. Read the following link and try legacy.sql https://github.com/mapserver/mapserver/issues/4186
There has been only two downloadable osm2pgsql versions for Windows ever and the newer is two years old now. Developers are developing for Linux. I used a little sum of money for getting the first Windows executable. Perhaps I will try the same trick later this year.