Hi Paul, Thank you very much for the input and the hint on how to get the whole error message. Attached are the error message file and the generated script file for your reference.
The commands used are: - shp2pgsql -s 3005 "..\AbaloneClosures.shp" hm_vect.AbaloneClosures2 > D:\tmp\AbaloneClosures2.sql - psql -h flash.HaidaMapping.local -d hm -U postgres -f D:\tmp\AbaloneClosures2.sql Based on the error message, the table "hm_vect"."abaloneclosures2" seemed created. However, it is not. Your input on the problem would be much appreciated! Thanks John Date: Sat, 13 Dec 2008 16:36:00 -0800 > From: "Paul Ramsey" <pram...@cleverelephant.ca> > Subject: Re: [postgis-users] Problem loading shape data > To: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net> > Message-ID: > <30fe546d0812131636v212853d8wa3422f29f4e14...@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > 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 <johnzhan...@gmail.com> 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 postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
