[postgis-users] isvalid(the_geom) crash my db

[strk at refractions.net]

Marco, I can execut isValid with no problems with 1.0.4/geos-2.1.4:

10=# select postgis_full_version();
                                        postgis_full_version                    
-----------------------------------------------------------------------------------------------------
 POSTGIS="1.0.4" GEOS="2.1.4" PROJ="Rel. 4.4.8, 3 May 2004" USE_STATS DBPROC="0.3.0" RELPROC="0.3.0"
(1 row)

10=# select isvalid('0106000020C310000001000000010300000001000000070000007AC67BF3AF1847C00E1330F2C9EB2BC08E4E4A29141947C03FCC53AD8CE72BC0AF5B383C651847C0C13AA2DC2CE72BC08311EDCEAB1747C0035D4287CFE92BC0BE575688CA1747C02DA4DF8DFFEB2BC032E4233F491847C011C11C3C21ED2BC07AC67BF3AF1847C00E1330F2C9EB2BC0'::geometry);
 isvalid
---------
 t
(1 row)

Still, there is no evident change which would have affected this call
since 1.0.0 in the ChangeLog...
Maybe a C++ lib issue ?  Did you compile postgresql against libstdc++ ?
Or, architecture-dependent.
Can you show output of SELECT version() as well ?

--strk;



On Fri, Sep 30, 2005 at 11:29:13AM -0300, Marco Vieira wrote:
> select astext(the_geom),the_geom
> from foo
> limit 1
> 
> returns:
> 
> MULTIPOLYGON(((-46.1928696016666 -13.9605251010594,-46.1959277737452
> -13.9522451557915,-46.1905894541918 -13.9515141437563,-46.1849306733666
> -13.9566614407072,-46.1858683034511 -13.9609340987682,-46.1897353101016
> -13.9631441865063,-46.1928696016666 -13.9605251010594)))
> 
> 0106000020C310000001000000010300000001000000070000007AC67BF3AF1847C00E1330F2C9EB2BC08E4E4A29141947C03FCC53AD8CE72BC0AF5B383C651847C0C13AA2DC2CE72BC08311EDCEAB1747C0035D4287CFE92BC0BE575688CA1747C02DA4DF8DFFEB2BC032E4233F491847C011C11C3C21ED2BC07AC67BF3AF1847C00E1330F2C9EB2BC0
> 
> Thank's for while.
> >
> > Could you provide the_geom value ?
> > 	SELECT the_geom from foo limit 1;
> > So we can test against new (and same) version...
> >
> > --strk;
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> 
> 
> Marco Vieira.
> Fone:    + 55 21 9499-6800
> marco_vieira at uk2.net
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users