X-Git-Url: https://git.tokkee.org/?a=blobdiff_plain;f=contrib%2Fpostgresql%2Fcollectd_insert.sql;fp=contrib%2Fpostgresql%2Fcollectd_insert.sql;h=00c5519b7a211cdfde7f283aa528805020f93dc3;hb=5090238f2bd3761778a19ef3f5e9d32911444324;hp=fb44bb4fe82bdc7f68cfc53a8263e8c260208b93;hpb=178db08806318e0b01de2e7a9261f18d6f7ca72d;p=collectd.git

diff --git a/contrib/postgresql/collectd_insert.sql b/contrib/postgresql/collectd_insert.sql
index fb44bb4f..00c5519b 100644
--- a/contrib/postgresql/collectd_insert.sql
+++ b/contrib/postgresql/collectd_insert.sql
@@ -104,7 +104,7 @@ CREATE OR REPLACE VIEW collectd
                     WHEN type_inst IS NOT NULL THEN '-'
                     ELSE ''
                 END
-                || coalesce(plugin_inst, '') AS identifier,
+                || coalesce(type_inst, '') AS identifier,
             tstamp, name, value
         FROM identifiers
             JOIN values