[postgis-users] Problem loading shape data

[Paul Ramsey]

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
>
>