[postgis-users] more effective way?

[Paul Ramsey]

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 <ki4gyw at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users