astext(geometry) does not exist (PostGis 2.0.1 Postgre 9.2 Windows)

General talk
#1

Hello Everybody.

I Would like to Host my Own OpenStreetMap TileServer.

So i have to Create my Own Tiles.

I already Set Up my System:

Windows XP
PostGis 2.0.1
PostGre 9.2.

I Downloaded osm2pgsql and Geodata.

But if i try to Import the Geodata in die Database, it get me an error:

astext(geometry) does not exist

Screenshot:

Please help me.

Thank you very much!

#2

Hi,

Some functions were renamed in PostGIS 2.0 to suit better with international standards. You can get the old names back by running “legacy.sql” in your database.
http://www.postgis.org/docs/PostGIS_FAQ.html#legacy_faq

#3

It worked fine! Thanks!! :slight_smile: