Hi there I'm running Postgresql 8.4 with postgis 1.5. I have a table that contains roughly 2000 records. The geometry in the table is a polygon.
I can run the following query with no problems select the_geom from mytable; However when I run something like this: select st_centroid(the_geom) from mytable; or select st_isvalid(the_geom) from mytable; I get the following error everytime: 2012-07-19 17:23:47 BST LOG: server process (PID 19445) was terminated by signal 11: Segmentation fault 2012-07-19 17:23:47 BST LOG: terminating any other active server processes 2012-07-19 17:23:47 BST LOG: all server processes terminated; reinitializing 2012-07-19 17:23:47 BST LOG: database system was interrupted; last known up at 2012-07-19 17:23:33 BST 2012-07-19 17:23:47 BST LOG: database system was not properly shut down; automatic recovery in progress 2012-07-19 17:23:47 BST LOG: record with zero length at 1406/B6388B94 2012-07-19 17:23:47 BST LOG: redo is not required 2012-07-19 17:23:47 BST LOG: autovacuum launcher started 2012-07-19 17:23:47 BST LOG: database system is ready to accept connections If I limit the query to 100 records it works. In the same table I have another geometry that is a point. When I run the st_isvalid against that, it does not error. What is strange is this has only just started happening. I thought it was a hardware issue, so I completely dumped the database and recreated it on another server but the issue persisted. I'm not sure what I have done wrong. The data originates from an mdb. The geom's were stored as OLE Objects. When I imported them into postgres they were bytea. I converted them with st_geomfromewkb(the_geom). Any help or directions on where I can go to figure out how to solve this issue would be great. Thanks Rebecca
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
