update materialised dashboard table

diff --git a/cgi-bin/pgstatus.pl b/cgi-bin/pgstatus.pl
index aa83566d95357ff8a530c1d52936ef349a2d0ab5..614fcf302099fb1530c1e88086524779fe66bd3b 100755 (executable)
--- a/cgi-bin/pgstatus.pl
+++ b/cgi-bin/pgstatus.pl
@@ -322,6 +322,12 @@ $row=$sth->fetchrow_arrayref;
 my ($os, $compiler,$arch) = @$row;
 $sth->finish;
 
 my ($os, $compiler,$arch) = @$row;
 $sth->finish;
 

+
+$db->begin_work;
+$db->do("delete from dashboard_mat");
+$db->do("insert into dashboard_mat select * from dashboard_mat_data");
+$db->commit;
+

 $db->disconnect;
 
 print "Content-Type: text/plain\n\n";
 $db->disconnect;
 
 print "Content-Type: text/plain\n\n";