[postgis-users] adding new shape data in existing PostGIS table

[Kefyalew Sahle]

 Hello,
   
I have got problem in adding new data in a table that already exist in PostGIS. 
I used the following command   
/usr/local/pgsql/bin/shp2pgsql  forest forest | /usr/local/pgsql/bin/psql -a forestrydb 

I received the following message 
ERROR:  relation "forest" already exists ............... 
ERROR:  current transaction is aborted, commands ignored until end of transaction block 
  When running without any options. The task is aborted. The following is the massage displayed after running the shp2pgsql command:
   Shapefile type: Polygon
 Postgis type: MULTIPOLYGON[2]
 BEGIN
 NOTICE: CREATE TABLE will create implicit sequence "forest_gid_seq1" for serial column "forest.gid"
 ERROR:  relation "forest" already exists
 ERROR:  current transaction is aborted, commands ignored until end of transaction block
 ERROR:  current transaction is aborted, commands ignored until end of transaction block
 ROLLBACK
   
Would you please provide me some information how I can append in my existing PostGIS 
database new data that is available in shape format?
Thanks in advance  

Kef
  

		
---------------------------------
Yahoo! Photos
 Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060107/a5a7ae52/attachment.html>