X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=planetlab5.sql;fp=planetlab5.sql;h=710e436cb1e0bf2f3164d80fa86ad20ce4f9155b;hb=25ca2c2fee216af894640248b6d83939f31ca327;hp=e686ecce385d5dc49163635b3e9b5765a5c41bc8;hpb=30abeea24f5e8911ce18426dc2947be1850a196c;p=plcapi.git

diff --git a/planetlab5.sql b/planetlab5.sql
index e686ecc..710e436 100644
--- a/planetlab5.sql
+++ b/planetlab5.sql
@@ -1045,7 +1045,7 @@ FROM peers;
 --------------------------------------------------------------------------------
 CREATE OR REPLACE VIEW node_tags AS
 SELECT node_id,
-array_accum(node_tag_id) AS tag_ids
+array_accum(node_tag_id) AS node_tag_ids
 FROM node_tag
 GROUP BY node_id;
 
@@ -1103,9 +1103,9 @@ AS ports,
 COALESCE((SELECT conf_file_ids FROM node_conf_files
 		 WHERE node_conf_files.node_id = nodes.node_id), '{}') 
 AS conf_file_ids,
-COALESCE((SELECT tag_ids FROM node_tags 
+COALESCE((SELECT node_tag_ids FROM node_tags 
 		 WHERE node_tags.node_id = nodes.node_id), '{}') 
-AS tag_ids,
+AS node_tag_ids,
 node_session.session_id AS session
 FROM nodes
 LEFT JOIN peer_node USING (node_id)