<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html style="direction: ltr;">
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body style="direction: ltr;" bidimailui-charset-is-forced="true"
bidimailui-detected-decoding-type="latin-charset" text="#000000"
bgcolor="#ffffff">
<p style="margin-bottom: 0cm; margin-top: 0pt;">On 06/02/2011 07:35,
Aren Cambre wrote:<br>
</p>
<blockquote
cite="mid:AANLkTimumnvJtHXRbmScOy_Vk_zHqBau+ceFD-2kz7MO@mail.gmail.com"
type="cite">I think the problem may actually be with the build of
GRASS GIS shipped with QGIS. I just installed 6.4.1 RC1 and now
get a useful error.</blockquote>
<br>
Could be that you came across a bug, but...<br>
If you're trying to import a PostGIS table into GRASS as a GRASS
vector, then you need to note what database GRASS is using. From the
error below your GRASS db connection ('db.connect -p') is local dbf
files. In that case I believe that several of the column headers
from the original PostGIS table are too long for the dbf format.
That might be part of the problem... Also it could be that some of
the data types from PostGIS aren't accepted by dbf.<br>
It might be best to move your whole GRASS database setup to sqlite -
more robust and full featured.<br>
<br>
<blockquote
cite="mid:AANLkTimumnvJtHXRbmScOy_Vk_zHqBau+ceFD-2kz7MO@mail.gmail.com"
type="cite">
<div><br>
</div>
<div>Aren<br>
<br>
<div class="gmail_quote">On Sat, Feb 5, 2011 at 10:15 PM, Aren
Cambre <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:aren@arencambre.com">aren@arencambre.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">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 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 style="margin: 0pt 0pt 0pt 40px; border: medium
none; padding: 0px;">
<div><img moz-do-not-send="true">Width for column
school_zone set to 255 (was not specified by OGR), some
strings may be truncated!</div>
<div>
<p style="margin: 0px; text-indent: 0px;">
<img moz-do-not-send="true">Width for column
vehicle_color set to 255 (was not specified by OGR),
some strings may be truncated!</p>
</div>
<div>
<p style="margin: 0px; text-indent: 0px;">
<img moz-do-not-send="true">Width for column
offense_location set to 255 (was not specified by
OGR), some strings may be truncated!</p>
</div>
<div>
<p style="margin: 0px; text-indent: 0px;">
<img moz-do-not-send="true">Width for column work_zone
set to 255 (was not specified by OGR), some strings
may be truncated!</p>
</div>
<div>
<p style="margin: 0px; text-indent: 0px;">
<span>DBMI-DBF driver error:</span></p>
</div>
<div>
<p style="margin: 0px; text-indent: 0px;">
<span><br>
</span></p>
</div>
<div>
<p style="margin: 0px; text-indent: 0px;"><span><br>
</span></p>
</div>
<div>
<p style="margin: 0px; text-indent: 0px;"><img
moz-do-not-send="true">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: 0px; text-indent: 0px;"><span
style="font-weight: 600;">Finished with error</span></p>
</div>
</blockquote>
<div>
<p style="margin: 0px; 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: 0px; text-indent: 0px;"><br>
</p>
<p style="margin: 0px; text-indent: 0px;">
I turned postgres logging to log all queries (following
the recipe at <a moz-do-not-send="true"
href="http://stackoverflow.com/questions/722221/how-to-log-postgres-sql-queries"
target="_blank">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: 0px; text-indent: 0px;"><br>
</p>
<p style="margin: 0px; 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: 0px; text-indent: 0px;"><br>
</p>
<p style="margin: 0px; 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: 0px; text-indent: 0px;">
<br>
</p>
<font color="#888888">
<p style="margin: 0px; text-indent: 0px;">Aren Cambre</p>
</font></div>
</blockquote>
</div>
<br>
</div>
<br>
This mail was received via Mail-SeCure System.<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
grass-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:grass-user@lists.osgeo.org">grass-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/grass-user">http://lists.osgeo.org/mailman/listinfo/grass-user</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="62">--
Micha Silver
<a class="moz-txt-link-freetext" href="http://www.surfaces.co.il/">http://www.surfaces.co.il/</a>
Arava Development Co. +972-52-3665918
</pre>
</body>
</html>