I see no attachment... the table would not be created because the whole load process runs in one transaction block. If the transaction fails, no table.
P On Mon, Dec 15, 2008 at 9:58 AM, John Zhang <johnzhan...@gmail.com> wrote: > 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 > > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
