[postgis-users] Shp2pgsql problem 2

TECHER David davidtecher at yahoo.fr
Wed Apr 18 04:27:44 PDT 2007


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



More information about the postgis-users mailing list