[Gdal-dev] ntf to postgres tables --- another problem

[Frank Warmerdam]

nida Khan wrote:
> Hi List,
> 
> I am trying to import NTF file into postgres table,
> There are 3 layers for this NTF file, it works fine for 2 of them but fails
> on thrid one.
> 
> This is the error I'm getting
> bash-2.05a$  ogr2ogr -update PG:dbname=test BIRMINGHAM_DISTRICT.NTF -lco
> "OVERWRITE=YES" "LAUNDER=YES" -nln birming_collection BL2000_COLLECTIONS
> ERROR 1: INSERT command for new feature failed.
> ERROR:  value too long for type character(6)

Nida,

While I gather you have dealt with this, you can also add the creation
option "PRECISION=NO" to force all string fields to use VARCHAR.  This should
avoid problems with unexpectedly long strings.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent