Well, this is weird. If I add <b><font class="Apple-style-span" face="'courier new', monospace">-t</font></b> ("Do not create attribute table" per <a href="http://grass.osgeo.org/grass64/manuals/html64_user/v.in.ogr.html">http://grass.osgeo.org/grass64/manuals/html64_user/v.in.ogr.html</a>), it all works.<div>
<br></div><div>I'm guessing this is a bug, so I've filed a report at <a href="http://trac.osgeo.org/grass/ticket/1274">http://trac.osgeo.org/grass/ticket/1274</a>.</div><div><br></div><div>Aren<br><br><div class="gmail_quote">
On Sun, Feb 6, 2011 at 4:57 PM, Aren Cambre <span dir="ltr"><<a href="mailto:aren@arencambre.com">aren@arencambre.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
I am flamboozled by this error. I am running GRASS GIS 6.4 on Windows 7 32 bit.<div><br></div><div>I am running this command (user ID and password redacted):</div><div><b><font face="'courier new', monospace">v.in.ogr -o "dsn=PG:dbname='de' host=localhost port=5432 user='XXX' password='YYY' sslmode=disable" layer=consistent.master output=master_grass4 --verbose</font></b></div>
<div><br></div><div>Here's the result:</div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><div><b>Over-riding projection check</b></div></div><div><div><b>Layer: consistent.master</b></div>
</div><div><div><b>Width for column school_zone set to 255 (was not specified by OGR), some strings may be truncated!</b></div></div><div><div><b>Width for column vehicle_color set to 255 (was not specified by OGR), some strings may be truncated!</b></div>
</div><div><div><b>Width for column offense_location set to 255 (was not specified by OGR), some strings may be truncated!</b></div></div><div><div><b>Width for column work_zone set to 255 (was not specified by OGR), some strings may be truncated!</b></div>
</div><div><div><b>DBMI-Postgres driver error:</b></div></div><div><div><b style="background-color:rgb(255, 255, 0)">Cannot connect to Postgres: fe_sendauth: no password</b></div></div><div><div><b style="background-color:rgb(255, 255, 0)">supplied</b></div>
</div><div><div><b>Unable to open database <host=localhost,dbname=de> by driver <pg></b></div></div><div><div><b>ERROR: Unable open database <host=localhost,dbname=de> by driver <pg></b></div></div>
</blockquote><div><br></div><div>I don't understand why I am getting the highlighted error. I am supplying the user ID and password for the DB's root <i>and only</i> user. I know these are correct; I've triple-checked. And it's able to read the database; otherwise it wouldn't be able to see those four columns and complain about the width.</div>
<div><br></div><div>Am I missing something?</div><div><br></div><font color="#888888"><div>Aren Cambre</div>
</font></blockquote></div><br></div>