[postgis-users] About Invalid OGC WKT Error

["Guillaume SUEUR (Géosignal)"]

If you type "select AsText(the_geom)..." what does it give ?



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.
> 
> 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
> 
> 

-- 
---------------------------
Guillaume SUEUR
GEOSIGNAL - Groupe BVA
25bis Avenue Marcel Dassault
31505 TOULOUSE CEDEX 5
----------------------------