[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