[postgis-users] About Invalid OGC WKT Error

[Koji Yano]

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