[postgis-users] Re: Problem loading shape data (Paul Ramsey)

[John Zhang]

 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" <pramsey at cleverelephant.ca>
> Subject: Re: [postgis-users] Problem loading shape data
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Message-ID:
>        <30fe546d0812131636v212853d8wa3422f29f4e142fc at 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 <johnzhang06 at 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
> >
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081215/32b827d2/attachment.html>