-
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