[postgis-users] About Invalid OGC WKT Error

[strk at refractions.net]

On Thu, Feb 03, 2005 at 08:25:36AM +0900, Koji Yano wrote:
> Thanks for replies! Und vielen dank!
> 
> > Did you also upgrade postgis scripts ?
> > Can you show the output of SELECT postgis_full_version() ?
> > --strk;
> 
> I loaded lwpostgis.sql to my database.
> Do I need to upgrade another scripts?
> Here is the output of SELECT postgis_full_version.
> 
> # select postgis_full_version();
>                                     postgis_full_version
> --------------------------------------------------------------------------------------------
>  POSTGIS="1.0.0RC2" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS
> DBPROC="0.1.0" RELPROC="0.1.0"
> (1 row)
> 
> > This is caused by the change of the canonical representation in
> > PostGIS 1.0.
> > All applications that use PostGIS specific ways to acces the GIS
> > data instead of standard OpenGIS methods will have to be fixed to work
> > with PostGIS 1.0.
> 
> > HTH,
> > Markus
> 
> So do I have to wait aplications like QGis to be fixed...?

Is the lwpostgis.sql you loaded the one which came from
RC1 or RC2 ?

Can you post the output of this queries ?

# SELECT proname, proargtypes from pg_proc where proname like '%fromtext' or proname like '%fromwkb';
# SELECT oid, typname from pg_type where typname = 'geometry' or typname = 'bytea' or typname = 'text';

--strk;

> 
> 
> 
> Guillaume SUEUR Write:
> > If you type "select AsText(the_geom)..." what does it give ?
> 
> Here is an output example.
> # select astext(the_geom) from gisdatatable where gid=1;
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>                              astext
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>  MULTIPOLYGON(((141.035285377798 45.4507354457091,141.032958339858
> 45.4610162489808,141.045848615774 45.4539431035632,141.067446903638
> 45.4241639435773,141.062595100902 45.4221717163604,141.056538079865
> 45.4064737088129,141.058535244559 45.3966829368604,141.054612589546
> 45.3889056878123,141.059839162516 45.3726268545911,141.059363349557
> 45.3515872077209,141.049321654719 45.3395223170193,141.056692145358
> 45.3193556419327,141.04902910682 45.3011413822968,141.044472448689
> 45.2979601730628,141.046357215354 45.2779280443239,141.042963667653
> 45.2740091757784,141.026810623885 45.2733924679721,141.015934178811
> 45.2840028147885,141.025733236061 45.2913415037452,141.022971765628
> 45.3090304072433,141.002572686158 45.3281468757037,141.003874097059
> 45.3355115895582,140.999437291206 45.3516080211105,140.983159922735
> 45.3794214592879,140.983645570306 45.3838827925359,140.990745575141
> 45.3861049857612,140.984850681887 45.3982041462972,140.991594093426
> 45.4069056447536,140.990404524719 45.4108027485794,140.984432787776
> 45.4106376332912,140.986524285306 45.4140878387132,140.982600936686
> 45.4148254664823,140.992617136244 45.4178376305474,140.994274328606
> 45.4239177333574,140.982555807873 45.4353006065475,140.966428710639
> 45.4390669232697,140.976913242282 45.4470829227784,140.966010892091
> 45.4570552907577,140.967277683122 45.4641638874124,140.979785808854
> 45.453779334493,140.981088081262 45.4487669317952,140.985549560962
> 45.4474000820403,140.985376208266 45.4434985962787,141.003309418124
> 45.4339344207041,141.018152413709 45.4335922419942,141.033298682861
> 45.4388615838839,141.037768534202 45.4428197807109,141.035285377798
> 45.4507354457091)))
> (1 row)
> 
> 
> Is there any problems ?
> 
> Koji Yano
> http://www.officeyano.net
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users