From b1e5a326cac8d2e2b3c46d0d8ab7e091f096ebb3 Mon Sep 17 00:00:00 2001
From: Tony Mack <tmack@cs.princeton.edu>
Date: Wed, 1 Aug 2007 17:01:01 +0000
Subject: [PATCH] - modified 'site_nodes' view to only return nodes that aren't
 marked 'deleted'

---
 planetlab4.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/planetlab4.sql b/planetlab4.sql
index 6853ecb9..2f47d015 100644
--- a/planetlab4.sql
+++ b/planetlab4.sql
@@ -9,7 +9,7 @@
 --
 -- Copyright (C) 2006 The Trustees of Princeton University
 --
--- $Id: planetlab4.sql,v 1.78 2007/05/17 16:06:46 tmack Exp $
+-- $Id: planetlab4.sql,v 1.79 2007/07/12 17:48:19 tmack Exp $
 --
 
 SET client_encoding = 'UNICODE';
@@ -293,6 +293,7 @@ CREATE VIEW site_nodes AS
 SELECT site_id,
 array_accum(node_id) AS node_ids
 FROM nodes
+WHERE deleted IS false
 GROUP BY site_id;
 
 -- slice whitelist on nodes
-- 
2.45.2