[postgis-devel] Garden test is failing on 1.4

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Fri Dec 12 03:13:06 PST 2008


Obe, Regina wrote:

> This could just be something funky with my install, but I ran the Garden 
> test on my 1.4, 3.1.0 GEOS, 8.3.1 install on OpenSUSE and its failing 
> when using ST_Accum with a
> 
> ERROR:  cache lookup failed for type 1107522 (the type varies from 0 to 
> some other number)
> 
> After dissecting it -- it doesn't always give a cached lookup fail with 
> ST_Accum, but sometimes gives me an array of booleans like {t,f,f,f,t}? 
> Though I don't seem to be able to recreate that behavior.
> 
> Anyrate if people can run this test and let me know if you see anything odd
> 
>         SELECT ST_Accum(the_geom)
>         FROM (SELECT ST_SetSRID(ST_Point(i,j),4326) As the_geom
>                 FROM generate_series(-60,50,5) As i
>                         CROSS JOIN generate_series(40,70, 5) j) As foo; 

Yeah, it looks as if I was a little bit too eager in removing some of 
the old code - I removed a section that was required to set the array 
type. Since this determines the memory alignment used for the array 
elements, PostgreSQL was getting confused. Please test latest SVN where 
you should find this is now fixed.

> Did we get rid of Postgis_JTS_Version().  I guess we should remove it 
> from the docs if we did.  Since it also fails on that.  I remarked out 
> of my testing that line.

Yeah, the JTS stuff got ripped out from trunk a long time ago...


ATB,

Mark.

-- 
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063



More information about the postgis-devel mailing list