<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<font face="Courier New" size="2"><span style="font-size:10pt;">
<div>Hi,</div>
<div>I have:</div>
<div>- downloaded GDAL v 1.7.2</div>
<div>- installed postgresql-devel (8.3.8)</div>
<div> </div>
<div>- downloaded and compiled/installed proj-4.7.0</div>
<div> </div>
<div>- downloaded ogdi-3.1.5 and later on ogdi-3.2.0-beta</div>
<div>- configured ogdi to use proj-4.7.0</div>
<div>- compiled and installed ogdi</div>
<div> </div>
<div>- configured GDAL: --with-ogdi=/usr/local --with-pg=/usr/bin/pg_config</div>
<div>- compiled/installed GDAL</div>
<div> </div>
<div>- ogr2ogr --formats, repordt bouth postgis and ogdi driver</div>
<div> </div>
<div>running ogr2ogr:</div>
<div>ogr2ogr -f PostgreSQL PG:"dbname=a1316120 host=127.0.0.1 port=5432 user=postgres password=postgrespwd"</div>
<div>gltp:/vrf/home/naval/gemaps/mapdata/Approach/a1316120/dnc13/a1316120 -t_srs "EPSG:4326" -lco OVERWRITE=YES -segmentize 0.5 -nln soundp soundp@hyd(*)_point'</div>
<div> </div>
<div>but when I try to import a DNC (VPF) chart I get the following error message:</div>
<div>ERROR 1: INSERT command for new feature failed.</div>
<div>ERROR: column "nan" does not exist</div>
<div>LINE 1: ...5263)'::TEXT) , 1, 'BE020', 1, 26, 1, nan, ...</div>
<div> ^</div>
<div>Command: INSERT INTO "soundp" ("wkb_geometry" , "id", "f_code", "acc", </div>
<div>"dat", "exs", "hdh", "hdp", "snd", "svc", "val", "tile_id", "end_id") </div>
<div>VALUES (GeomFromEWKT('SRID=4326;POINT (-119.614990234375114 </div>
<div>34.420528411865263)'::TEXT) , 1, 'BE020', 1, 26, 1, nan, </div>
<div>3.600000, 10, 5, 0, 1, 1) </div>
<div>ERROR 1: Terminating translation prematurely </div>
<div>after failed translation of layer soundp@hyd(*)_point (use </div>
<div>-skipfailures to skip errors)</div>
<div> </div>
<div>It is the same with ogdi-3.1.5 and ogdi-3.2.0-beta.</div>
<div>why is hdh = nan (the corresponding hdp is correct), it works when importing with ogr2ogr from FWTOOLS.</div>
<div> </div>
<div>What am I doing wrong, it worked before when I used an prebuild FWTOOLS?</div>
<div> </div>
<div>I need GDAL 1.7.2 because the version in FWTOOLS has another bug (S-57 ignores names starting with ÅÄÖ).</div>
<div>Is there some one that could tell me what i'm doing wrong, please?</div>
<div> </div>
<div>I'm using postgresql 8.3.8 on linux redhat 5.x.</div>
<div>Kind regards,</div>
<div>Paul</div>
<div> </div>
<div><font face="Arial"> </font></div>
</span></font>
</body>
</html>