From deb3abc707846d54491a01b777296d707b0bedeb Mon Sep 17 00:00:00 2001
From: Andrew Dunstan <andrew@dunslane.net>
Date: Wed, 11 Feb 2009 01:27:09 +0000
Subject: [PATCH] update materialised dashboard table

---
 cgi-bin/pgstatus.pl | 6 ++++++
 1 file changed, 6 insertions(+)

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";
-- 
2.30.2