[postgis-devel] [PostGIS] #1219: Unexpected typmod in points loaded via shp2pgsql

PostGIS trac at osgeo.org
Tue Sep 27 03:41:55 PDT 2011


#1219: Unexpected typmod in points loaded via shp2pgsql
---------------------+------------------------------------------------------
 Reporter:  strk     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 Yah I noticed this myself.  It's because we don't have anyway of
 representing -1 but figured that was still on the todo so was going to
 press the point later.
   BTW there is no way for me to get SRID 0 back though I desperately want
 it even if I explicitly ask for 0.

 e.g.

 {{{
 CREATE TABLE testpit(pit geometry(Point,0))

 INSERT INTO testpit(pit)
 SELECT ST_SetSRID(ST_Point(1,0),0);

 SELECT ST_SRID(pit) FROM testpit;
 --result --
 -1
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1219#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-devel mailing list