X-Git-Url: https://git.octo.it/?a=blobdiff_plain;f=contrib%2Fpostgresql%2Fcollectd_insert.sql;h=bee182cb715f703605c7983a2cccbb2c12f3af37;hb=f5adf265a374e5e0dba89a4a9903e7719dc57039;hp=fb44bb4fe82bdc7f68cfc53a8263e8c260208b93;hpb=3b51243382501d5f3cdda79d30c7ecf39d22dd87;p=collectd.git

diff --git a/contrib/postgresql/collectd_insert.sql b/contrib/postgresql/collectd_insert.sql
index fb44bb4f..bee182cb 100644
--- a/contrib/postgresql/collectd_insert.sql
+++ b/contrib/postgresql/collectd_insert.sql
@@ -33,8 +33,8 @@
 -- and 'values' to store the value-list identifier and the actual values
 -- respectively.
 --
--- The 'values' table is partitioned to improve performance and maintainance.
--- Please note that additional maintainance scripts are required in order to
+-- The 'values' table is partitioned to improve performance and maintenance.
+-- Please note that additional maintenance scripts are required in order to
 -- keep the setup running -- see the comments below for details.
 --
 -- The function 'collectd_insert' may be used to actually insert values
@@ -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