[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