[postgis-devel] polygonize

[strk at refractions.net]

On Sun, Dec 19, 2004 at 02:09:56PM -0500, Carl Anderson wrote:
> strk at refractions.net wrote:
> 
> >On Sun, Dec 19, 2004 at 11:22:09AM -0500, Carl Anderson wrote:
> > 
> >
> >>btw
> >>
> >>select polygonize_garray(array_append('{}',the_geom) from shapes;
> >>Causes a backend ABEND;
> >>   
> >>
> >
> >Does collect_garray(array_append('{}',the_geom) from shapes work ?
> >
> >--strk;
> > 
> >
> That also ABENDs the backend;
> 
> C.

This is an old problem. The problem is that collect_garray expects
an array of PG_LWGEOM *pointers*, while array_append builds an array
of PG_LWGEOM *toasts*.

Those queries should work if written as:

 select polygonize_garray(geom_accum('{}',the_geom) from shapes;
 select collect_garray(geom_accum('{}',the_geom) from shapes;

--strk;

> 
> > 
> >
> >> C.                
> >>_______________________________________________
> >>postgis-devel mailing list
> >>postgis-devel at postgis.refractions.net
> >>http://postgis.refractions.net/mailman/listinfo/postgis-devel
> >>   
> >>
> >_______________________________________________
> >postgis-devel mailing list
> >postgis-devel at postgis.refractions.net
> >http://postgis.refractions.net/mailman/listinfo/postgis-devel
> > 
> >
> 
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel