X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=planetlab5.sql;h=0fd11aade09cd75186a333eea9121d6fcc0e79fe;hb=8711362afb2a503aff4694a4975e52c0df083688;hp=382589fb3fa41f631d39a4cc5c72f2932b55e565;hpb=a27f49323d4addd120f164cddaafe967b0d71f3d;p=plcapi.git

diff --git a/planetlab5.sql b/planetlab5.sql
index 382589f..0fd11aa 100644
--- a/planetlab5.sql
+++ b/planetlab5.sql
@@ -500,7 +500,7 @@ CREATE TABLE interface_setting (
 
 CREATE OR REPLACE VIEW interface_settings AS 
 SELECT interface_id,
-array_accum(interface_setting_id) AS setting_ids
+array_accum(interface_setting_id) AS interface_setting_ids
 FROM interface_setting
 GROUP BY interface_id;
 
@@ -534,7 +534,7 @@ interfaces.dns1,
 interfaces.dns2,
 interfaces.bwlimit,
 interfaces.hostname,
-COALESCE((SELECT setting_ids FROM interface_settings WHERE interface_settings.interface_id = interfaces.interface_id), '{}') AS setting_ids
+COALESCE((SELECT interface_setting_ids FROM interface_settings WHERE interface_settings.interface_id = interfaces.interface_id), '{}') AS interface_setting_ids
 FROM interfaces;
 
 --------------------------------------------------------------------------------