[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