[postgis-users] Append only new features

[brizey02]

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

(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
table
-- 
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.