AW: [postgis-users] Shp2pgsql problem 2

[Stefan Hahmann]

Oops,

Sorry actually i did

shp2pgsql -s 4326 -a -I -D -k myshapefile2.shp public._g24 | psql -d mapdata

And then i got the error.  (ERROR:  syntax error at or near "2760003221743" at character 1 LINE 1: 2760003221743 4110 0 100000000005583 0 522760200562014 0 0 1...)

I have copied the lines to http://paste.lisp.org/display/39917

Best regards.

Franks is right

Please paste your command on a web site like http://paste.lisp.org/

then send us the url from it ;)


Frank Koormann a écrit :
> * Stefan Hahmann <s.hahmann at mapchart.com> [070418 12:06]:
>   
>> Hi frank, david
>>
>> Thank you for your help with the shapefile import. Switching off the 
>> 32-bit option and changing the way the shp2pgsql | psql commands were 
>> invoked did help.
>>
>> But now another problem occured:
>>
>> After i have successfully loaded data into my table _g24 using
>>
>> shp2pgsql -s 4326 -c -I -D -k myshapefile1.shp public._g24 | psql -d 
>> mapdata
>>
>> I was not able to append data using
>>
>> shp2pgsql -s 4326 -c -I -D -k myshapefile2.shp public._g24 | psql -d 
>> mapdata
>>     
>
> If the above is your actual command line, you don't append data but 
> try to overwrite existing data.
>
>   
>> Although myshapefile1.shp and myshapefile2 do have the same structure.
>>     
>  
> It would be helpful to get the get the first few lines from the first 
> series of sql statements (up to and including the COPY line) and from 
> the second series at least all up to the line cousing the error.
>
> Regards,
>
>         Frank
>
>   


	

	
		
___________________________________________________________________________
Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire.
http://fr.mail.yahoo.com
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users