From: Bernd Ahlers <bernd@tuneafish.de>
Date: Mon, 10 Jun 2013 13:48:14 +0000 (+0200)
Subject: Unbreak type_inst value in collectd psql view.
X-Git-Tag: collectd-5.3.1~2^2~5
X-Git-Url: https://git.tokkee.org/?p=collectd.git;a=commitdiff_plain;h=5090238f2bd3761778a19ef3f5e9d32911444324

Unbreak type_inst value in collectd psql view.

Signed-off-by: Florian Forster <octo@collectd.org>
---

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