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

Paul Ramsey pramsey at cleverelephant.ca
Mon Dec 15 10:35:04 PST 2008


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 <johnzhang06 at 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" <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
>> >
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>



More information about the postgis-users mailing list