[postgis-users] pointfromtext

strk at refractions.net strk at refractions.net
Sun Dec 11 13:47:19 PST 2005


On Sun, Dec 11, 2005 at 01:57:10PM +0100, Luca wrote:
> strk at refractions.net ha scritto:
> 
> >On Sun, Dec 11, 2005 at 01:04:20PM +0100, Luca wrote:
> > 
> >
> >>im tring to update a column in this way:
> >>UPDATE sites SET geom = pointfromtext('POINT('||latitudine||' 
> >>'||longitudine||' '||quota||')',26591);
> >>where pointfromtext is a function and latitudine, longitudine and quota 
> >>are others columns... but this dont work
> >>psql said:
> >>
> >>WARNING:  OGC WKT expected, EWKT provided - use GeomFromEWKT() for this
> >>CONTEXT:  funzione SQL "geomfromtext" istruzione 1
> >>funzione SQL "pointfromtext" istruzione 1
> >>
> >>but the function  GeomFromEWKT() doesnt exist..
> >>any idea?
> >>   
> >>
> >
> >Might be a screwed postgis installation (the missing GeomFromEWKT())
> >What does postgis_full_version() say ?
> > 
> >
> it say: POSTGIS="1.0.6" GEOS="2.1.4" PROJ="Rel. 4.4.9, 29 Oct 2004" 
> USE_STATS DBPROC="0.3.0" RELPROC="0.3.0"

Can you find 'geomfronewkt' in pg_proc ?
Did you get GeomFromEWKT() takes a text argument ?
--strk;



More information about the postgis-users mailing list