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

[nida Khan]

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)

ERROR 1: Terminating translation prematurely after failed
translation of layer BL2000_COLLECTIONS

I also tried to select few fields from that NTF file to a .dbf file but that
fails as welll due to integerList datatype.

bash-2.05a$ ogr2ogr -select poly_id,census_code,admin_name shp_files/
BIRMINGHAM_DISTRICT.NTF BL2000_COLLECTIONS
ERROR 6: Can't create fields of type IntegerList on shapefile layers.

Is there a way to resolve this problem???

Regards
Nida.