# Pastebin ADJ1HkWA SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET SET SET psql:pg_area_dump.sql:44: ERROR: relation "area" already exists ALTER TABLE psql:pg_area_dump.sql:73: ERROR: relation "area_alias" already exists ALTER TABLE psql:pg_area_dump.sql:88: ERROR: relation "area_alias_id_seq" already exists ALTER TABLE ALTER SEQUENCE psql:pg_area_dump.sql:111: ERROR: relation "area_alias_type" already exists ALTER TABLE psql:pg_area_dump.sql:126: ERROR: relation "area_alias_type_id_seq" already exists ALTER TABLE ALTER SEQUENCE psql:pg_area_dump.sql:145: ERROR: relation "area_annotation" already exists ALTER TABLE psql:pg_area_dump.sql:158: ERROR: relation "area_gid_redirect" already exists ALTER TABLE psql:pg_area_dump.sql:173: ERROR: relation "area_id_seq" already exists ALTER TABLE ALTER SEQUENCE psql:pg_area_dump.sql:196: ERROR: relation "area_type" already exists ALTER TABLE psql:pg_area_dump.sql:211: ERROR: relation "area_type_id_seq" already exists ALTER TABLE ALTER SEQUENCE psql:pg_area_dump.sql:240: ERROR: relation "link" already exists ALTER TABLE psql:pg_area_dump.sql:253: ERROR: relation "link_attribute_text_value" already exists ALTER TABLE psql:pg_area_dump.sql:280: ERROR: relation "link_type" already exists ALTER TABLE psql:pg_area_dump.sql:292: ERROR: relation "iso_3166_1" already exists ALTER TABLE psql:pg_area_dump.sql:304: ERROR: relation "iso_3166_2" already exists ALTER TABLE psql:pg_area_dump.sql:316: ERROR: relation "iso_3166_3" already exists ALTER TABLE psql:pg_area_dump.sql:337: ERROR: relation "l_area_area" already exists ALTER TABLE psql:pg_area_dump.sql:352: ERROR: relation "l_area_area_id_seq" already exists ALTER TABLE ALTER SEQUENCE psql:pg_area_dump.sql:380: ERROR: relation "l_area_url" already exists ALTER TABLE psql:pg_area_dump.sql:395: ERROR: relation "l_area_url_id_seq" already exists ALTER TABLE ALTER SEQUENCE psql:pg_area_dump.sql:415: ERROR: relation "link_attribute" already exists ALTER TABLE psql:pg_area_dump.sql:428: ERROR: relation "link_attribute_credit" already exists ALTER TABLE psql:pg_area_dump.sql:446: ERROR: relation "link_attribute_type" already exists ALTER TABLE psql:pg_area_dump.sql:461: ERROR: relation "link_attribute_type_id_seq" already exists ALTER TABLE ALTER SEQUENCE psql:pg_area_dump.sql:479: ERROR: relation "link_creditable_attribute_type" already exists ALTER TABLE psql:pg_area_dump.sql:494: ERROR: relation "link_id_seq" already exists ALTER TABLE ALTER SEQUENCE psql:pg_area_dump.sql:512: ERROR: relation "link_text_attribute_type" already exists ALTER TABLE psql:pg_area_dump.sql:527: ERROR: relation "link_type_attribute_type" already exists ALTER TABLE psql:pg_area_dump.sql:542: ERROR: relation "link_type_id_seq" already exists ALTER TABLE ALTER SEQUENCE psql:pg_area_dump.sql:565: ERROR: relation "url" already exists ALTER TABLE psql:pg_area_dump.sql:578: ERROR: relation "url_gid_redirect" already exists ALTER TABLE psql:pg_area_dump.sql:593: ERROR: relation "url_id_seq" already exists ALTER TABLE ALTER SEQUENCE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE psql:pg_area_dump.sql:119664: ERROR: insert or update on table "area" violates foreign key constraint "area_fk_type" DETAIL: Key (type)=(9) is not present in table "area_type". psql:pg_area_dump.sql:187059: ERROR: insert or update on table "area_alias" violates foreign key constraint "area_alias_fk_area" DETAIL: Key (area)=(2621) is not present in table "area". psql:pg_area_dump.sql:187070: ERROR: duplicate key value violates unique constraint "area_alias_type_pkey" DETAIL: Key (id)=(1) already exists. CONTEXT: COPY area_alias_type, line 1 psql:pg_area_dump.sql:187086: ERROR: insert or update on table "area_annotation" violates foreign key constraint "area_annotation_fk_area" DETAIL: Key (area)=(1178) is not present in table "area". psql:pg_area_dump.sql:187282: ERROR: insert or update on table "area_gid_redirect" violates foreign key constraint "area_gid_redirect_fk_new_id" DETAIL: Key (new_id)=(1813) is not present in table "area". psql:pg_area_dump.sql:187299: ERROR: duplicate key value violates unique constraint "area_type_pkey" DETAIL: Key (id)=(1) already exists. CONTEXT: COPY area_type, line 1 psql:pg_area_dump.sql:187565: ERROR: insert or update on table "iso_3166_1" violates foreign key constraint "iso_3166_1_fk_area" DETAIL: Key (area)=(1) is not present in table "area". psql:pg_area_dump.sql:192412: ERROR: insert or update on table "iso_3166_2" violates foreign key constraint "iso_3166_2_fk_area" DETAIL: Key (area)=(261) is not present in table "area". psql:pg_area_dump.sql:192429: ERROR: insert or update on table "iso_3166_3" violates foreign key constraint "iso_3166_3_fk_area" DETAIL: Key (area)=(244) is not present in table "area". psql:pg_area_dump.sql:311341: ERROR: insert or update on table "l_area_area" violates foreign key constraint "l_area_area_fk_link" DETAIL: Key (link)=(118734) is not present in table "link". psql:pg_area_dump.sql:690469: ERROR: insert or update on table "l_area_url" violates foreign key constraint "l_area_url_fk_link" DETAIL: Key (link)=(118732) is not present in table "link". psql:pg_area_dump.sql:1549850: ERROR: relation "link_type" does not exist LINE 8: AND NOT (SELECT has_dates FROM link_type WHERE id = N... ^ QUERY: SELECT (NEW.begin_date_year IS NOT NULL OR NEW.begin_date_month IS NOT NULL OR NEW.begin_date_day IS NOT NULL OR NEW.end_date_year IS NOT NULL OR NEW.end_date_month IS NOT NULL OR NEW.end_date_day IS NOT NULL OR NEW.ended = TRUE) AND NOT (SELECT has_dates FROM link_type WHERE id = NEW.link_type) CONTEXT: PL/pgSQL function musicbrainz.check_has_dates() line 3 at IF COPY link, line 1: "48067 148 \N \N \N \N \N \N 2 2012-05-15 20:52:02.141676+00 f" psql:pg_area_dump.sql:2236831: ERROR: relation "link" does not exist LINE 4: JOIN link l ON l.id = la.link ^ QUERY: SELECT NOT EXISTS ( SELECT TRUE FROM (VALUES (NEW.link, NEW.attribute_type)) la (link, attribute_type) JOIN link l ON l.id = la.link JOIN link_type lt ON l.link_type = lt.id JOIN link_attribute_type lat ON lat.id = la.attribute_type JOIN link_type_attribute_type ltat ON ltat.attribute_type = lat.root AND ltat.link_type = lt.id ) CONTEXT: PL/pgSQL function musicbrainz.prevent_invalid_attributes() line 3 at IF COPY link_attribute, line 1: "4 477 2011-05-16 15:03:23.368437+00" psql:pg_area_dump.sql:2327981: ERROR: insert or update on table "link_attribute_credit" violates foreign key constraint "link_attribute_credit_fk_link" DETAIL: Key (link)=(186492) is not present in table "link". psql:pg_area_dump.sql:2385347: ERROR: insert or update on table "link_attribute_text_value" violates foreign key constraint "link_attribute_text_value_fk_link" DETAIL: Key (link)=(172527) is not present in table "link". psql:pg_area_dump.sql:2386471: ERROR: duplicate key value violates unique constraint "link_attribute_type_pkey" DETAIL: Key (id)=(582) already exists. CONTEXT: COPY link_attribute_type, line 1 psql:pg_area_dump.sql:2387518: ERROR: duplicate key value violates unique constraint "link_creditable_attribute_type_pkey" DETAIL: Key (attribute_type)=(14) already exists. CONTEXT: COPY link_creditable_attribute_type, line 10 psql:pg_area_dump.sql:2387530: ERROR: duplicate key value violates unique constraint "link_text_attribute_type_pkey" DETAIL: Key (attribute_type)=(830) already exists. CONTEXT: COPY link_text_attribute_type, line 1 psql:pg_area_dump.sql:2388118: ERROR: duplicate key value violates unique constraint "link_type_pkey" DETAIL: Key (id)=(12) already exists. CONTEXT: COPY link_type, line 1 psql:pg_area_dump.sql:2388543: ERROR: duplicate key value violates unique constraint "link_type_attribute_type_pkey" DETAIL: Key (link_type, attribute_type)=(241, 511) already exists. CONTEXT: COPY link_type_attribute_type, line 3 COPY 10482301 COPY 8902 setval -------- 68029 (1 row) setval -------- 4 (1 row) setval -------- 119803 (1 row) setval -------- 10 (1 row) setval -------- 119713 (1 row) setval -------- 382463 (1 row) setval -------- 1271 (1 row) setval -------- 953603 (1 row) setval -------- 1098 (1 row) setval ---------- 10036969 (1 row) psql:pg_area_dump.sql:12879840: ERROR: multiple primary keys for table "area_alias" are not allowed psql:pg_area_dump.sql:12879848: ERROR: multiple primary keys for table "area_alias_type" are not allowed psql:pg_area_dump.sql:12879856: ERROR: multiple primary keys for table "area_annotation" are not allowed psql:pg_area_dump.sql:12879864: ERROR: multiple primary keys for table "area_gid_redirect" are not allowed psql:pg_area_dump.sql:12879872: ERROR: multiple primary keys for table "area" are not allowed psql:pg_area_dump.sql:12879880: ERROR: multiple primary keys for table "area_type" are not allowed psql:pg_area_dump.sql:12879888: ERROR: multiple primary keys for table "iso_3166_1" are not allowed psql:pg_area_dump.sql:12879896: ERROR: multiple primary keys for table "iso_3166_2" are not allowed psql:pg_area_dump.sql:12879904: ERROR: multiple primary keys for table "iso_3166_3" are not allowed psql:pg_area_dump.sql:12879912: ERROR: multiple primary keys for table "l_area_area" are not allowed psql:pg_area_dump.sql:12879920: ERROR: multiple primary keys for table "l_area_url" are not allowed psql:pg_area_dump.sql:12879928: ERROR: multiple primary keys for table "link_attribute_credit" are not allowed psql:pg_area_dump.sql:12879936: ERROR: multiple primary keys for table "link_attribute" are not allowed psql:pg_area_dump.sql:12879944: ERROR: multiple primary keys for table "link_attribute_text_value" are not allowed psql:pg_area_dump.sql:12879952: ERROR: multiple primary keys for table "link_attribute_type" are not allowed psql:pg_area_dump.sql:12879960: ERROR: multiple primary keys for table "link_creditable_attribute_type" are not allowed psql:pg_area_dump.sql:12879968: ERROR: multiple primary keys for table "link" are not allowed psql:pg_area_dump.sql:12879976: ERROR: multiple primary keys for table "link_text_attribute_type" are not allowed psql:pg_area_dump.sql:12879984: ERROR: multiple primary keys for table "link_type_attribute_type" are not allowed psql:pg_area_dump.sql:12879992: ERROR: multiple primary keys for table "link_type" are not allowed psql:pg_area_dump.sql:12880000: ERROR: multiple primary keys for table "url_gid_redirect" are not allowed psql:pg_area_dump.sql:12880008: ERROR: multiple primary keys for table "url" are not allowed psql:pg_area_dump.sql:12880015: ERROR: relation "area_alias_idx_area" already exists psql:pg_area_dump.sql:12880022: ERROR: relation "area_alias_idx_primary" already exists psql:pg_area_dump.sql:12880029: ERROR: relation "area_alias_idx_txt" already exists psql:pg_area_dump.sql:12880036: ERROR: relation "area_alias_idx_txt_sort" already exists psql:pg_area_dump.sql:12880043: ERROR: relation "area_alias_type_idx_gid" already exists psql:pg_area_dump.sql:12880050: ERROR: relation "area_gid_redirect_idx_new_id" already exists psql:pg_area_dump.sql:12880057: ERROR: relation "area_idx_gid" already exists psql:pg_area_dump.sql:12880064: ERROR: relation "area_idx_name" already exists psql:pg_area_dump.sql:12880071: ERROR: relation "area_idx_name_txt" already exists psql:pg_area_dump.sql:12880078: ERROR: relation "area_type_idx_gid" already exists psql:pg_area_dump.sql:12880085: ERROR: relation "iso_3166_1_idx_area" already exists psql:pg_area_dump.sql:12880092: ERROR: relation "iso_3166_2_idx_area" already exists psql:pg_area_dump.sql:12880099: ERROR: relation "iso_3166_3_idx_area" already exists psql:pg_area_dump.sql:12880106: ERROR: relation "l_area_area_idx_entity1" already exists psql:pg_area_dump.sql:12880113: ERROR: relation "l_area_area_idx_uniq" already exists psql:pg_area_dump.sql:12880120: ERROR: relation "l_area_url_idx_entity1" already exists psql:pg_area_dump.sql:12880127: ERROR: relation "l_area_url_idx_uniq" already exists psql:pg_area_dump.sql:12880134: ERROR: relation "link_attribute_type_idx_gid" already exists psql:pg_area_dump.sql:12880141: ERROR: relation "link_idx_type_attr" already exists psql:pg_area_dump.sql:12880148: ERROR: relation "link_type_idx_gid" already exists psql:pg_area_dump.sql:12880155: ERROR: relation "url_gid_redirect_idx_new_id" already exists psql:pg_area_dump.sql:12880162: ERROR: relation "url_idx_gid" already exists psql:pg_area_dump.sql:12880169: ERROR: relation "url_idx_url" already exists CREATE TRIGGER CREATE TRIGGER CREATE TRIGGER psql:pg_area_dump.sql:12880197: ERROR: function musicbrainz.search_area_alias_delete() does not exist psql:pg_area_dump.sql:12880204: ERROR: function musicbrainz.search_area_alias_insert() does not exist psql:pg_area_dump.sql:12880211: ERROR: function musicbrainz.search_area_alias_update() does not exist psql:pg_area_dump.sql:12880218: ERROR: function musicbrainz.search_area_annotation_delete() does not exist psql:pg_area_dump.sql:12880225: ERROR: function musicbrainz.search_area_annotation_insert() does not exist psql:pg_area_dump.sql:12880232: ERROR: function musicbrainz.search_area_annotation_update() does not exist psql:pg_area_dump.sql:12880239: ERROR: function musicbrainz.search_area_delete() does not exist psql:pg_area_dump.sql:12880246: ERROR: function musicbrainz.search_area_insert() does not exist psql:pg_area_dump.sql:12880253: ERROR: function musicbrainz.search_area_type_delete() does not exist psql:pg_area_dump.sql:12880260: ERROR: function musicbrainz.search_area_type_insert() does not exist psql:pg_area_dump.sql:12880267: ERROR: function musicbrainz.search_area_type_update() does not exist psql:pg_area_dump.sql:12880274: ERROR: function musicbrainz.search_area_update() does not exist psql:pg_area_dump.sql:12880281: ERROR: function musicbrainz.search_iso_3166_1_delete() does not exist psql:pg_area_dump.sql:12880288: ERROR: function musicbrainz.search_iso_3166_1_insert() does not exist psql:pg_area_dump.sql:12880295: ERROR: function musicbrainz.search_iso_3166_1_update() does not exist psql:pg_area_dump.sql:12880302: ERROR: function musicbrainz.search_iso_3166_2_delete() does not exist psql:pg_area_dump.sql:12880309: ERROR: function musicbrainz.search_iso_3166_2_insert() does not exist psql:pg_area_dump.sql:12880316: ERROR: function musicbrainz.search_iso_3166_2_update() does not exist psql:pg_area_dump.sql:12880323: ERROR: function musicbrainz.search_iso_3166_3_delete() does not exist psql:pg_area_dump.sql:12880330: ERROR: function musicbrainz.search_iso_3166_3_insert() does not exist psql:pg_area_dump.sql:12880337: ERROR: function musicbrainz.search_iso_3166_3_update() does not exist psql:pg_area_dump.sql:12880344: ERROR: function musicbrainz.search_link_delete() does not exist psql:pg_area_dump.sql:12880351: ERROR: function musicbrainz.search_link_insert() does not exist psql:pg_area_dump.sql:12880358: ERROR: function musicbrainz.search_link_type_delete() does not exist psql:pg_area_dump.sql:12880365: ERROR: function musicbrainz.search_link_type_insert() does not exist psql:pg_area_dump.sql:12880372: ERROR: function musicbrainz.search_link_type_update() does not exist psql:pg_area_dump.sql:12880379: ERROR: function musicbrainz.search_link_update() does not exist psql:pg_area_dump.sql:12880386: ERROR: function musicbrainz.search_url_delete() does not exist psql:pg_area_dump.sql:12880393: ERROR: function musicbrainz.search_url_insert() does not exist psql:pg_area_dump.sql:12880400: ERROR: function musicbrainz.search_url_update() does not exist