[postgis-users] shp2pgsql fails on malformed integer attribute

2010-08-15 Thread Andrea Peri
>I don't quite understand your example : > >"if the field numeric in the shapefile instead of be fill with numbers was >filled with '1', '2', '3', etc... >where the number are however not really numbers but text based, an action of >importing always 0. >Will be more confusing. The user don't und

Re: [postgis-users] shp2pgsql fails on malformed integer attribute

2010-08-14 Thread Aman Verma
14, 2010 3:18 AM To: PostGIS Users Discussion Subject: [postgis-users] shp2pgsql fails on malformed integer attribute > aman.verma at mcgill.ca<http://mcgill.ca> wrote.. >If you use shp2pgsql to upload a shapefile with an attribute table that has a >malformed integer >(like a

[postgis-users] shp2pgsql fails on malformed integer attribute

2010-08-14 Thread Andrea Peri
> aman.verma at mcgill.ca wrote.. >If you use shp2pgsql to upload a shapefile with an attribute table that has a malformed integer >(like a letter), shp2pgsql will not correct it, and the upload will fail. >Normally, I would view this as 'expected behaviour' (garbage in, garbage out). However, I

Re: [postgis-users] shp2pgsql fails on malformed integer attribute

2010-08-13 Thread Paul Ramsey
Aman, Thanks for the informative post. Could you put the relevant parts and your example file into the issue tracker at http://trac.osgeo.org/postgis so we have a record of it? I can see the benefit in handling data in the "way others do" for maximum ease of use. Yours, Paul On Fri, Aug 13, 2010

[postgis-users] shp2pgsql fails on malformed integer attribute

2010-08-13 Thread Aman Verma
Hi everybody, This is my first post to the list. Please let me know (flame) if this is not a suitable place to post. If you use shp2pgsql to upload a shapefile with an attribute table that has a malformed integer (like a letter), shp2pgsql will not correct it, and the upload will fail. Normal