I am running <b>v.in.ogr</b> to import a PostGIS table. This table shows up fine in QGIS. Here's the command:<div><b><font class="Apple-style-span" face="'courier new', monospace">v.in.ogr -o "dsn=PG:dbname='de' host=localhost port=5432 user='[redacted]' password='[redacted]' sslmode=disable" layer=consistent.master output=master_grassX</font></b></div>
<div><br></div><div>This command was produced by QGIS's GRASS Tools.</div><div><br></div><div>The problem is that I get an error but no explanation at all. Here's the output:</div><blockquote class="webkit-indent-blockquote" style="margin: 0 0 0 40px; border: none; padding: 0px;">
<div><img src="C:/PROGRA~1/QUANTU~2/apps/qgis/./themes/default/grass/grass_module_warning.png">Width for column school_zone set to 255 (was not specified by OGR), some strings may be truncated!</div><div><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
<img src="C:/PROGRA~1/QUANTU~2/apps/qgis/./themes/default/grass/grass_module_warning.png">Width for column vehicle_color set to 255 (was not specified by OGR), some strings may be truncated!</p></div><div><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
<img src="C:/PROGRA~1/QUANTU~2/apps/qgis/./themes/default/grass/grass_module_warning.png">Width for column offense_location set to 255 (was not specified by OGR), some strings may be truncated!</p></div><div><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
<img src="C:/PROGRA~1/QUANTU~2/apps/qgis/./themes/default/grass/grass_module_warning.png">Width for column work_zone set to 255 (was not specified by OGR), some strings may be truncated!</p></div><div><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
<span style=" font-family:'Courier New,courier';">DBMI-DBF driver error:</span></p></div><div><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
<span style=" font-family:'Courier New,courier';"><br></span></p></div><div><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'Courier New,courier';"><br>
</span></p></div><div><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><img src="C:/PROGRA~1/QUANTU~2/apps/qgis/./themes/default/grass/grass_module_error.png">Unable to create table: 'create table master_grassX (cat integer, offense_street_name varchar ( 30 ), school_zone varchar ( 255 ), defendant_dl varchar ( 20 ), defendant_dl_state varchar ( 2 ), vehicle_model varchar ( 20 ), offense_code integer, vehicle_color varchar ( 255 ), citation_id_base varchar ( 20 ), vehicle_make varchar ( 20 ), defendant_dob date, speed_limit integer, source varchar ( 20 ), vehicle_registration_expiration_date date, offense_crossstreet_number varchar ( 10 ), defendant_sex varchar ( 1 ), citing_jurisdiction integer, offense_county varchar ( 10 ), officer_id varchar ( 20 ), offense_location varchar ( 255 ), defendant_zip varchar ( 9 ), vehicle_licenseplate_state varchar ( 2 ), offense_street_number varchar ( 10 ), offense_timestamp datetime, citation_id_stub varchar ( 20 ), offense_crossstreet_name varchar ( 30 ), speed_alleged integer, vehicle_year integer, vehicle_licenseplate varchar ( 10 ), work_zone varchar ( 255 ), defendant_race varchar ( 10 ))'</p>
</div><div><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-weight:600;">Finished with error</span></p></div></blockquote><div><p></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">The problem is I get no details at all on the error cause. Yes, the driver error really is blank.</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><br></p><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
I turned postgres logging to log all queries (following the recipe at <a href="http://stackoverflow.com/questions/722221/how-to-log-postgres-sql-queries">http://stackoverflow.com/questions/722221/how-to-log-postgres-sql-queries</a>). I analyzed the queries and didn't see anything surprising. I've attached the log in case it's helpful.</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><br></p><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
I checked the <b>/dbf</b> directory, and it has no files. I also checked the <b>vector/master_grassX</b> directory and found no problems, just four files (<b>coor</b>, <b>dbln</b>, <b>head</b>, <b>hist</b>) with unsurprising contents.</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><br></p><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
I'm new to GRASS, so I'm not sure what else to check. Is there another log source? Did I discover a bug that needs to be filed?</p><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
<br></p><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Aren Cambre</p></div>