[postgis-users] About Invalid OGC WKT Error

strk at refractions.net strk at refractions.net
Wed Feb 2 08:40:46 PST 2005


On Thu, Feb 03, 2005 at 01:37:19AM +0900, Koji Yano wrote:
> Hello list.
> 
> After I upgraded PostGIS to 1.0.0RC2 from 0.9.1,
>  I have some problems in working with PostGIS.

Did you also upgrade postgis scripts ?
Can you show the output of SELECT postgis_full_version() ?
--strk;

> 
> Example1:
> There is a table that contains id, name, geom fields.
> 
> # INSERT INTO [table]
> VALUES(1,'test',geometryfromtext('POLYGON((135.45......))',4326);
> ERROR:  Invalid OGC WKT (does not start with P,L,M or G)
> 
> I think it starts with P...Do I get wrong?
> 
> Example2:
> I ran shp2pgsql and imported some shape files successfully.
> When I use only 'Select the_geom', I got a result
> like 0106000020E610000001000000010300000001000000660000009C9FD6D...
> Although I can see proper WKT data by 'Astext' function,
> the same message(Invalid...) appears when I try to view geometry data of
> PostGIS by QGis.
> 
> Environments are following.
>  Turbolinux 10
>  PostgreSQL 8.0.1
>  PostGIS 1.0.0rc-2
>  Proj4.4.9
>  GEOS 2.0.1
>  shp2pgsql support UTF-8
> 
> I did not have any problems about installing.
> I appliciate your help.
> 
> Koji Yano
> http://www.officeyano.net
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list