<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body dir="ltr" bgcolor="#ffffff" text="#000000">
<p style="margin-bottom: 0cm; margin-top: 0pt;">Rich Shepard wrote:<br>
</p>
<blockquote
cite="mid:alpine.LNX.2.00.1103170714160.24161@salmo.appl-ecosys.com"
type="cite"> One of the tables I'm copying from dbf to the postgres
database threw an
<br>
error:
<br>
<br>
DBMI-Postgres driver error:
<br>
Cannot create table:
<br>
create table hydro_pointEvent ( cat integer, ComID integer, Permanent_
<br>
varchar(40), EventDate varchar(10), ReachCode varchar(14), ReachSMDat
<br>
varchar(10), ReachResol integer, FeatureCom integer, Feature_Pe
varchar(40),
<br>
FeatureCla integer, Source_Ori varchar(130), Source_Dat varchar(100),
<br>
Source_Fea varchar(40), FeatureDet varchar(254), Measure double
precision,
<br>
Offset double precision, EventType integer )
<br>
ERROR: syntax error at or near "Offset"
<br>
LINE 1: ...eatureDet varchar(254), Measure double precision, Offset
dou...
<br>
</blockquote>
<br>
"Offset" is a postgres (SQL) reserved word. Can you change that column
name in the dbf?<br>
<br>
<blockquote
cite="mid:alpine.LNX.2.00.1103170714160.24161@salmo.appl-ecosys.com"
type="cite">
^
<br>
WARNING: Unable to create table <hydro_pointEvent>
<br>
WARNING: Copy table failed
<br>
<br>
Is there a protocol I can use within GRASS to identify the syntax
error?
<br>
<br>
TIA,
<br>
<br>
Rich
<br>
<br>
_______________________________________________
<br>
grass-user mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:grass-user@lists.osgeo.org">grass-user@lists.osgeo.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/grass-user">http://lists.osgeo.org/mailman/listinfo/grass-user</a>
<br>
<br>
This mail was received via Mail-SeCure System.
<br>
<br>
<br>
</blockquote>
<br>
</body>
</html>