You have to scroll up in the window until you can see what the *actual* error is... increase your command terminal scroll buffers to 5000 then re-run and scroll up to the first error message.
On Fri, Dec 12, 2008 at 3:17 PM, John Zhang <[email protected]> wrote: > Hi there, > > I used shp2pgsql command to convert shape data to postgis. I met a problem > when I tried to run the generated sql data file. > > The command is as follows: > > shp2pgsql -s 3005 "..\AbaloneClosures.shp" hm_vect.AbaloneClosures > > D:\tmp\AbaloneClosures.sql | psql -h flash.HaidaMapping.local -d hm -U > postgres -f D:\tmp\AbaloneClosures.sql > > the message tells: "..current transaction is aborted..". However, when I > copied the command to a query window to run, it was successful. It is a > polygon feature class with less than 1000 rows. > > When I ran > psql -h flash.HaidaMapping.local -d hm -U postgres -f > D:\tmp\AbaloneClosures.sql > the same problem occurred. > > Any input would be appreciated. > > Thanks a lot > John > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
