You can run ddl in a transaction context, so the best way is to . Upload data to mynewtable . Begin . Alter table mytable rename to myoldtable . Alter table mynewtable rename to mytable . Commit . Drop table myoldtable
P. On 2012-06-03, at 7:02 AM, chris brisendine <ki4...@gmail.com> wrote: > 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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
