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