Paul,
I think that the problem is with the SQL command built by the PostgreSQL driver. In the INSERT command a numeric field with the value NaN should be mentioned in quotes. Please file a ticket at http://trac.osgeo.org/gdal/newticket Mention the output for the command ogrinfo -al -so gltp:/vrf/home/naval/gemaps/mapdata/Approach/a1316120/dnc13/a1316120 sou...@hyd(*)_point' to describe the field types (especially 'hdh') of the source features. On Wed, Jun 30, 2010 at 10:36 AM, Malm Paul <[email protected]> wrote: > Hi, > I have: > - downloaded GDAL v 1.7.2 > - installed postgresql-devel (8.3.8) > > - downloaded and compiled/installed proj-4.7.0 > > - downloaded ogdi-3.1.5 and later on ogdi-3.2.0-beta > - configured ogdi to use proj-4.7.0 > - compiled and installed ogdi > > - configured GDAL: --with-ogdi=/usr/local --with-pg=/usr/bin/pg_config > - compiled/installed GDAL > > - ogr2ogr --formats, repordt bouth postgis and ogdi driver > > running ogr2ogr: > ogr2ogr -f PostgreSQL PG:"dbname=a1316120 host=127.0.0.1 port=5432 > user=postgres password=postgrespwd" > gltp:/vrf/home/naval/gemaps/mapdata/Approach/a1316120/dnc13/a1316120 -t_srs > "EPSG:4326" -lco OVERWRITE=YES -segmentize 0.5 -nln soundp sou...@hyd > (*)_point' > > but when I try to import a DNC (VPF) chart I get the following error > message: > ERROR 1: INSERT command for new feature failed. > ERROR: column "nan" does not exist > LINE 1: ...5263)'::TEXT) , 1, 'BE020', 1, 26, 1, nan, ... > ^ > Command: INSERT INTO "soundp" ("wkb_geometry" , "id", "f_code", "acc", > "dat", "exs", "hdh", "hdp", "snd", "svc", "val", "tile_id", "end_id") > VALUES (GeomFromEWKT('SRID=4326;POINT (-119.614990234375114 > 34.420528411865263)'::TEXT) , 1, 'BE020', 1, 26, 1, nan, > > 3.600000, 10, 5, 0, 1, 1) > ERROR 1: Terminating translation prematurely > after failed translation of layer sou...@hyd(*)_point (use > -skipfailures to skip errors) > > It is the same with ogdi-3.1.5 and ogdi-3.2.0-beta. > why is hdh = nan (the corresponding hdp is correct), it works when > importing with ogr2ogr from FWTOOLS. > > What am I doing wrong, it worked before when I used an prebuild FWTOOLS? > > I need GDAL 1.7.2 because the version in FWTOOLS has another bug (S-57 > ignores names starting with ÅÄÖ). > Is there some one that could tell me what i'm doing wrong, please? > > I'm using postgresql 8.3.8 on linux redhat 5.x. > Kind regards, > Paul > > > > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev > -- Best regards, Chaitanya kumar CH. /tʃaɪθənjə/ /kʊmɑr/ +91-9494447584 17.2416N 80.1426E
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
