ERROR: 23505: duplicate key value violates unique constraint "materialized_view_pages_fullpaths_idx" DETAIL: Key (nodeid, languagecode, siteid)=(2, de, 5) already exists. CONTEXT: SQL statement "INSERT INTO m3content.materialized_view_pages_fullpaths SELECT fpview.* FROM m3content.view_m3content_pages_fullpaths AS fpview /* WHERE (fpview.nodeid, fpview.siteid, fpview.languagecode) NOT IN ( SELECT fpmat.nodeid, fpmat.siteid, fpmat.languagecode FROM m3content.materialized_view_pages_fullpaths AS fpmat )*/" PL/pgSQL function "create_materialized_pages_fullpaths" line 49 at EXECUTE statement SQL statement "SELECT m3content.create_materialized_pages_fullpaths()" PL/pgSQL function "pages_xml_getpagebypageid" line 5 at PERFORM SQL statement "SELECT * FROM m3content.pages_xml_getpagebypageid( p_pageid, p_langcode, p_siteid )" PL/pgSQL function "pages_xml_cache_getpagebypageid" line 89 at SQL statement LOCATION: _bt_check_unique, nbtinsert.c:388