Ticket #2341 ([raster] st_mapalgebra mask parameter) created
Wed, May 22 2013 at 01:59PM EDT From PostGISMapAlgebra? should accept a mask to allow for focal statistics and other weighted mask operations.
wiki.php.2.txt attached to WikiStart
Tue, May 21 2013 at 01:35PM EDT From OpenLayersChangeset [11483]: don't bother regress testing shp2pgsql-gui on 32 bit anymroe. It fails on ...
Tue, May 21 2013 at 02:23AM EDT From PostGISdon't bother regress testing shp2pgsql-gui on 32 bit anymroe. It fails on shp_destroy on winnie buildbot for unknown reasons. I still blame liblwgeom pseudo shared state for all my problems.
Ticket #2340 (typmod check error crashing when in trigger on windows 64-bit EDB) created
Mon, May 20 2013 at 10:12AM EDT From PostGISThe tickets crash noted in #2338 I isolated to:
drop table if exists a ;
SELECT '<#1320>';
CREATE TABLE A ( geom geometry(MultiPolygon, 4326),
geog geography(MultiPolygon, 4326) );
CREATE OR REPLACE FUNCTION triga() RETURNS trigger AS
$$ BEGIN
NEW.geom = ST_GeometryN(New.geom,1);
NEW.geog = ST_GeometryN(New.geog::geometry,1)::geography;
RETURN NEW;
END; $$ language plpgsql VOLATILE;
CREATE TRIGGER triga_before
BEFORE INSERT ON a FOR EACH ROW
EXECUTE PROCEDURE triga();
-- run these a couple of times
INSERT INTO a(geog) VALUES('SRID=4326;MULTIPOLYGON (((0 0, 10 0, 10 10, 0 0)))'::geography);
INSERT INTO a(geom) VALUES('SRID=4326;MULTIPOLYGON (((0 0, 10 0, 10 10, 0 0)))'::geometry);
-- first time ERROR: Geometry type (Polygon) does not match column type (MultiPolygon) -- second time crash
crash Seems to be happening in postgis\gserialized_typmod.c around line 141 in postgis_valid_typmod function:
http://postgis.net/docs/doxygen/2.1/d4/df6/gserialized__typmod_8c_source.html#l00141
I suspect all parts have same issue
this is running on a windows 2008 R2 64bit server
POSTGIS="2.1.0beta3dev r11482" GEOS="3.4.0dev-CAPI-1.8.0 r0" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.7.8" LIBJSON="UNKNOWN" RASTER PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 64-bit
and get similar failure with 2.0.4 branch.