X-Git-Url: https://git.octo.it/?a=blobdiff_plain;f=contrib%2Fpostgresql%2Fcollectd_insert.sql;fp=contrib%2Fpostgresql%2Fcollectd_insert.sql;h=fb44bb4fe82bdc7f68cfc53a8263e8c260208b93;hb=9a84a669c98b90fad45d943b56d5d3f3b3ba8c97;hp=778de864eed13606e45bda2ab7f0a9b8f8e09944;hpb=25e9d1cb2d4fd2908b48640997e0922888ec5d8e;p=collectd.git

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[]