Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 2 down vote favorite

I was attempting to import a polyline roads layer into postgis, using both SPIT in QGIS 1.7 and postGIS GUI for this purpose. I have received errors through both processes as described here:

  • SPIT

The database gave an error while executing this SQL: INSERT INTO "public"."highways"("STREET","FROMLEFT","TOLEFT","FROMRIGHT","TORIGHT","STREETCODE","OBJID","USERID","FJUNCTION","TJUNCTION","LENGTH","ROA... (rest of SQL trimmed) The error was: ERROR: value too long for type character varying(31)

  • postGIS GUI

Error msg. from postGIS

What can be the problem and how can I fix it?

Thanks for your response.

Dor

share|improve this question
Just to update that I have overcame this obstacle; unfortunatly by using ArcCatalog. With it I was able to drop the fields that I didn't want, and one of them caused the problem. – dof1985 Jan 17 at 9:19

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.