Further note: Doing an ST_IsEmpty on one of these monsters shows its not empty.
ST_GeometryType(..) returns ST_Geometry and when I try to do an ST_Mem_Size on one, I hmm get this ERROR: lwgeom_size called with unknown-typed serialized geometry When try ST_IsValid get this ERROR: Unknown geometry type: 0 I'm going to try to repeat the process of copy from good table to see if the problem disappears. I suppose it could be disk corruption of some sort. Thanks, Regina -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paragon Corporation Sent: Friday, February 05, 2010 4:55 PM To: 'PostGIS Development Discussion' Subject: [postgis-devel] Has anyone seen this before? What would result in an UNKNOWN geometry type. One of our clients is getting this error when they try to vacuum analyze their table. > NOTICE: compute_serialized_box3d called on unknown type 0NOTICE: > compute_serialized_box3d called on unknown type 0 ... On closer inspection -- I see that there are UNKNOWNs and those UNKNOWNS are not NULL but the ST_AsText looks blank viewed via psql select count(*), GeometryType(the_geom) from badtable group by GeometryType(the_geom); count | geometrytype -------+-------------- 98483 | MULTIPOLYGON 1517 | UNKNOWN This is running on ---------------------------------------------------------------------------- ---- POSTGIS="1.3.6" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS PostgreSQL 8.4.1 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20 071124 (Red Hat 4.1.2-42), 64-bit They say the table was created by doing a create table badtable as select * from goodtable order by addr_num_tlid limit 100000; the goodtable doesn't exhibit this bizarre behavior. Not sure if this is a PostgreSQL bug or PostGIS bug. Any thoughts? Thanks, Regina _______________________________________________ postgis-devel mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-devel _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
