-
Documentation task
-
Resolution: Fixed
-
Major
-
None
-
6.0.0
-
Sprint 85 (Feb 2022)
-
0.1
Steps to reproduce:
https://www.zabbix.com/documentation/6.0/en/manual/appendix/install/db_primary_keys
Result:
PostgreSQL section:
\copy history_old TO '/tmp/history.csv' DELIMITER ',' CSV
CREATE TEMP TABLE temp_history (
itemid bigint NOT NULL,
clock integer DEFAULT '0' NOT NULL,
value DOUBLE PRECISION DEFAULT '0.0000' NOT NULL,
ns integer DEFAULT '0' NOT NULL
);
\copy temp_history FROM '/tmp/history.csv' DELIMITER ',' CSV
INSERT INTO history_uint SELECT * FROM temp_history ON CONFLICT (itemid,clock,ns) DO NOTHING;
Expected:
INSERT INTO history SELECT * FROM temp_history ON CONFLICT
- caused by
-
ZBXNEXT-6921 Use primary keys for historical tables (PoC)
-
- Closed
-