From 9a84a669c98b90fad45d943b56d5d3f3b3ba8c97 Mon Sep 17 00:00:00 2001 From: Sebastian Harl Date: Thu, 15 Nov 2012 15:14:45 +0100 Subject: [PATCH] collectd_insert.sql: Use timestamptz rather than timestamp. Don't want to get messed-up values after daylight-savings changes. --- contrib/postgresql/collectd_insert.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/contrib/postgresql/collectd_insert.sql b/contrib/postgresql/collectd_insert.sql index 778de864..fb44bb4f 100644 --- a/contrib/postgresql/collectd_insert.sql +++ b/contrib/postgresql/collectd_insert.sql @@ -85,7 +85,7 @@ CREATE INDEX identifiers_type_inst ON identifiers USING btree (type_inst); CREATE TABLE "values" ( id integer NOT NULL, - tstamp timestamp without time zone NOT NULL, + tstamp timestamp with time zone NOT NULL, name character varying(64) NOT NULL, value double precision NOT NULL ); @@ -188,7 +188,7 @@ CREATE TRIGGER insert_values_trigger -- SET constraint_exclusion = on; CREATE OR REPLACE FUNCTION collectd_insert( - timestamp, character varying, + timestamp with time zone, character varying, character varying, character varying, character varying, character varying, character varying[], character varying[], double precision[] -- 2.30.2