[postgis-tickets] [PostGIS] #2591: shp2pgsql field length problem

[PostGIS]

#2591: shp2pgsql field length problem
---------------------+------------------------------------------------------
 Reporter:  agnar    |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 1.5.9
Component:  postgis  |     Version:  1.5.X        
 Keywords:           |  
---------------------+------------------------------------------------------
 Bug found on shp2pgsql (5098 2010-01-04).
 My version is recently installed on a Debian server using apt.  It might
 not be the newest version, but the bug may still exist?

 My shape file contained a field of type text(20).
 The corresponding sql-file contained a corresponding declaration of
 varying(20).

 Subsequent inserts of records having exact 20 characters for that field
 failed. Editing the sql file to varying(21) resolved the problem.

 But I would expect shp2pgsql to handle this eventuality.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2591>
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.