SOLVED CDR Archive Server

[dgxa]

Hello all, I try to move my CDR to other fusionpbx and I am take the sample of the documentation CDR Archive Server and I have conflic when make the insert from temp tables to originals tables.

For example on the load of v_xml_cdr show this error:

INSERT INTO v_xml_cdr SELECT DISTINCT ON (xml_cdr_uuid) * FROM tmp_xml_cdr ON CONFLICT DO NOTHING;

ERROR: syntax error at or near "ON"
LINE 1: ...ECT DISTINCT ON (xml_cdr_uuid) * FROM tmp_xml_cdr ON CONFLIC...

Someone can help me with this please.

postgresql 9.4 || Debian 11 || fusionpbx 5.0.5

 

[ad5ou]

"ON CONFLICT DO NOTHING" is a feature not available in Postgresql 9.4 This feature wasn't added until version 11 iirc

 

[dgxa]

"ON CONFLICT DO NOTHING" is a feature not available in Postgresql 9.4 This feature wasn't added until version 11 iirc

Thank you @ad5ou