[postgis-tickets] [PostGIS] #2180: Postgres crashes on insert statement

PostGIS trac at osgeo.org
Thu Jan 17 14:16:16 PST 2013


#2180: Postgres crashes on insert statement
--------------------------+-------------------------------------------------
 Reporter:  MarkRobinson  |       Owner:  robe         
     Type:  defect        |      Status:  new          
 Priority:  critical      |   Milestone:  PostGIS 2.0.3
Component:  buildbots     |     Version:  2.0.x        
 Keywords:                |  
--------------------------+-------------------------------------------------

Comment(by robe):

 Mark,

 This doesn't crash on my windows 7 PostgreSQL 64-bit 9.1.3 2.0.0, 2.0.2
 (or 2.1.0SVN).  Unfortunately I don't have 9.1.4 readily handy or 2.0.1.
 So I'll need to retest later.

 Which windows version are you using?

 Can you check what your PostgreSQL logs say.  All I get is an error which
 is expected:

 {{{
  Geometry SRID (0) does not match column SRID (26915)

 }}}

 You should be doing:


 {{{
 INSERT INTO geometries (GEOM) VALUES (ST_GeomFromText('POINT(396210
 363290)',26915));
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2180#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list