Welcome, Guest. Please login or register.

Login with username, password and session length
Forums Search:  


Author Topic: error in water step  (Read 2772 times)

Tsnake

  • Jr. Member
  • **
  • Posts: 21
  • Karma: 0
    • View Profile
error in water step
« on: September 12, 2008, 03:29:06 PM »
I type the command psql -d postgis -h localhost -U postgres -f nhd_area.sql  and I get a whole list of errors.  They read psql:nhd_area.sql:1749:  ERROR: current transaction is aborted, commands ignored until end of transaction block.  The 1749 starts at 1 and eventually I get an abort program screen.

Please help.

-Oz-

  • Map Maker!
  • Administrator
  • Expert Advisor
  • *****
  • Posts: 1579
  • Karma: 27
    • View Profile
    • GPSFileDepot
Re: error in water step
« Reply #1 on: September 13, 2008, 12:22:15 AM »
how large is the nhd_area.sql file?  I'm assuming there is a bad character of some sort.  The error is on line 1749.  If you get notepad++ (thats what I use to open large files) you can go to the line.  If the file is too large to email (try zipping it, that'll help then send to services @ gpsfiledepot.com (remove the spaces around @)), just copy that line here and I can most likely figure it out quickly.
Dan Blomberg
Administrator - GPSFileDepot
GPS Units: Garmin Dakota 20, Garmin GPSMap 60csx, Nuvi 255W, Nuvi 250W, ForeRunner 110, Fenix 2, Tactix Bravo, Foretrex 401
See/Download My Maps!