From: Andrew Dunstan <andrew@dunslane.net>
Date: Wed, 11 Feb 2009 01:27:09 +0000 (+0000)
Subject: update materialised dashboard table
X-Git-Url: https://git.exim.org/buildfarm-server.git/commitdiff_plain/deb3abc707846d54491a01b777296d707b0bedeb

update materialised dashboard table
---

diff --git a/cgi-bin/pgstatus.pl b/cgi-bin/pgstatus.pl
index aa83566..614fcf3 100755
--- 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;
 
+
+$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";