AW: [postgis-users] shp2pgsql Error

[Jeff Lounsbury]

If you look at the file in arcview, is there scientific notation in the table
fields?
-Jeff

Düster Horst wrote:

> Hi
>
> My shape files where produced by ArcView 3.x
>
> Horst
>
> -----Ursprüngliche Nachricht-----
> Von: Jeff Lounsbury [mailto:jeffloun at refractions.net]
> Gesendet am: Dienstag, 2. Juli 2002 18:05
> An: postgis-users at postgis.refractions.net
> Betreff: Re: [postgis-users] shp2pgsql Error
>
> Apparently you have some Scientific notation in an Integer column that the
> pg_atoi function dislikes.
> Are you getting this shapefile from arcview 3.x or arcmap 8 or where?
> -Jeff
>
> Düster Horst wrote:
>
> > Hi
> >
> > During import a shape (small or large) with shp2pgsql after a time it
> arises
> > the following error message:
> >
> > ERROR:  copy: line 1, pg_atoi: error in "1.51460000000000E+04": can't
> parse
> > ".51460000000000E+04"
> > PQendcopy: resetting connection
> >
> > Please let me kow your hints
> >
> > Horst
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users