[postgis-users] Append only new features

brizey02 ki4gyw at gmail.com
Mon Jan 19 21:17:07 PST 2009

when i run this 
psql -d geoserver -f /home/storm/addnewwarnings.sql


insert into allpoly
select * from tempallpoly
where wfo||'_'||type||'_'||etn
not in (select distinct wfo||'_'||type||'_'||etn from allpoly);

it gives me:
psql:/home/storm/addnewwarnings.sql:4: ERROR:  duplicate key violates unique
constraint "allpoly_pkey"

I am droping the tempallpoly table before i repopulate it with the warnings,
and then after the query it should load any new warnings to the allpoly
View this message in context: http://www.nabble.com/Append-only-new-features-tp21524382p21557259.html
Sent from the PostGIS - User mailing list archive at Nabble.com.

More information about the postgis-users mailing list