Code

Unbreak type_inst value in collectd psql view.
authorBernd Ahlers <bernd@tuneafish.de>
Mon, 10 Jun 2013 13:48:14 +0000 (15:48 +0200)
committerFlorian Forster <octo@collectd.org>
Sun, 16 Jun 2013 07:39:29 +0000 (09:39 +0200)
Signed-off-by: Florian Forster <octo@collectd.org>
contrib/postgresql/collectd_insert.sql

index fb44bb4fe82bdc7f68cfc53a8263e8c260208b93..00c5519b7a211cdfde7f283aa528805020f93dc3 100644 (file)
@@ -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