[postgis-devel] Vegetable Gardening

Paragon Corporation lr at pcorp.us
Wed Nov 24 20:49:31 PST 2010


Here's an interesting -- well maybe not so interesting one.  I would expect
ST_DumpPoints to work for everything.

But when I do this query in R  (my spi query looks like this:

	pggeom20log <<- pg.spi.exec("SELECT logid
,log_label,func,g1,g2,log_start,log_end, 
	   date_part('epoch',age(log_end, log_start))  As dur_sec 
	FROM postgis_garden_log ORDER BY log_start")


table(pggeom20log$func, pggeom20log$dur_sec,useNA="ifany") 

I scan the results and see that ST_DumpPoints fails in 2 instances.  I look
at the log table and its failing on NULL geometry and Multiple NULLS (well
Multiple NULLS is kind of dum - so its really the NULL geometry).

Its been failing in past versions as well so not a cause of your changes

ST_Dump works for everything though including NULLs.  I'll put this one in
as a bug ticket item.


-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Wednesday, November 24, 2010 8:08 PM
To: PostGIS Development Discussion
Subject: [postgis-devel] Vegetable Gardening

While I love that the garden tests find things that otherwise would be
unfindable, I find dealing with the error reports a little hard.
"Here's a piece of SQL that generates 48 different function call
combinations, one of them fails." Is there any easier way to get the one
vegetable I want out of the garden?

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





More information about the postgis-devel mailing list