I have a postgis table that contains radar. My problem is every 3 minutes I update the radar table and sometimes the end user has no radar showing due to the new data loading is there a more effective way than doing it like I am with the following code,
shp2pgsql -D -a -s 4269 last.shp base05 > base05.sql psql -c "TRUNCATE TABLE base05" -d wxserver psql -d wxserver -f base05.sql I was dropping the table but that would cause my wms server to freakout. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users