GPSFileDepot Forums

General Category => Map Making Support => Topic started by: Tsnake on September 12, 2008, 03:29:06 PM

Title: error in water step
Post by: Tsnake 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.
Title: Re: error in water step
Post by: -Oz- 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.