[mapserver-users] postgis - geomfromtext problem

[Ahmet Temiz]

hello

I upgraded my postgis to 2.1.0.

But this version of postgis doesn't accept "geomfromtext" (instead
"ST_GeomFromText" only )

But:
following mapserver - java related codes produce "geomfromtext" and
then give error:

jeoLayer1.setData("geom from  (select gid,label,geom from sjeo_yas6)
as foo  using unique gid using srid=4326 ");
String f = "label=" + "'" + yas + "'";
jeoLayer1.setFilter(f);

msDrawMap(): Image handling error. Failed to draw layer named
'(null)'.;msPostGISLayerWhichShapes(): Query error. Error (ERROR:
function geomfromtext(unknown, integer) does not exist
LINE 1: ...'hex') as geom,"gid" from sjeo_yas6 where geom && GeomFromTe...



I compiled mapserver 6.0.1

what can I do ?

regards

-- 
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Planlama ve Zarar Azaltma Dairesi Başkanlığı

Eskişehir Yolu 10. km.
Lodumlu / Ankara
Tel : 0 312 2872680 / 1535


Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] postgis - geomfromtext problem

[Rahkonen Jukka]

Hi,

Perhaps running legacy.sql in your new database will be enough.
http://www.postgis.org/docs/PostGIS_FAQ.html#legacy_faq

-Jukka Rahkonen-

Ahmet Temiz wrote:


 
> hello
> 
> I upgraded my postgis to 2.1.0.
> 
> But this version of postgis doesn't accept "geomfromtext" (instead
> "ST_GeomFromText" only )
> 
> But:
> following mapserver - java related codes produce "geomfromtext" and then
> give error:
> 
> jeoLayer1.setData("geom from  (select gid,label,geom from sjeo_yas6) as
> foo  using unique gid using srid=4326 "); String f = "label=" + "'" + yas + 
> "'";
> jeoLayer1.setFilter(f);
> 
> msDrawMap(): Image handling error. Failed to draw layer named
> '(null)'.;msPostGISLayerWhichShapes(): Query error. Error (ERROR:
> function geomfromtext(unknown, integer) does not exist LINE 1: ...'hex') as
> geom,"gid" from sjeo_yas6 where geom && GeomFromTe...
> 
> 
> 
> I compiled mapserver 6.0.1
> 
> what can I do ?
> 
> regards
> 
> --
> Ahmet Temiz
> Jeoloji Müh.
> Afet ve Acil Durum Yönetimi Başkanlığı
> Planlama ve Zarar Azaltma Dairesi Başkanlığı
> 
> Eskişehir Yolu 10. km.
> Lodumlu / Ankara
> Tel : 0 312 2872680 / 1535
> 
> 
> Ahmet Temiz
> Geological Eng.
> Information Systems - GIS Group
> Disaster and Emergency Management
> of Presidency
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users