Last active
July 16, 2018 21:08
-
-
Save joshwiens/fe905ddda19d7d8672eccdb5cc6069ce to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| postgres@postgres-migration:/home/d3viant0ne$ pg_restore -h 127.0.0.1 -p 5433 -d easymetrics --disable-triggers -U postgres prod-labor_performance-pgdump.dmp | |
| Password: | |
| pg_restore: [archiver (db)] Error while PROCESSING TOC: | |
| pg_restore: [archiver (db)] Error from TOC entry 6830; 0 17663 TABLE DATA lookup_table_1000033_51_1 lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "client_lookup.lookup_table_1000033_51_1" does not exist | |
| Command was: ALTER TABLE client_lookup.lookup_table_1000033_51_1 DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "client_lookup.lookup_table_1000033_51_1" does not exist | |
| Command was: COPY client_lookup.lookup_table_1000033_51_1 (record_id, fld_1, fld_2, fld_3) FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "client_lookup.lookup_table_1000033_51_1" does not exist | |
| Command was: ALTER TABLE client_lookup.lookup_table_1000033_51_1 ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6832; 0 17671 TABLE DATA import_history_1000043_boundary_job_code lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: ALTER TABLE import.import_history_1000043_boundary_job_code DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: COPY import.import_history_1000043_boundary_job_code (import_format_file_id, row_number, facility_id, facility_code, employee_id, employee_code, process_id, process_code, shift_id, scan_date, start_time, end_time, vehicle, login_time, logout_time, scan_minutes, isindirect, isignore, day_indicator, ignore_reason, trip_percent, lift_percent, utilization_percent) FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: ALTER TABLE import.import_history_1000043_boundary_job_code ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6833; 0 17679 TABLE DATA import_history_scans_1000015 lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: ALTER TABLE import.import_history_scans_1000015 DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: COPY import.import_history_scans_1000015 (row_id, import_id, import_format_file_id, row_number, facility_id, department_id, process_id, process_code, shift_id, employee_id, customer_id, grouping_tier_option_id_1, item_id, scan_date, start_time, end_time, scan_minutes, isignore, ignore_reason, "metric_Qty", "metric_Order No", "metric_Delivery No", "metric_Package No", "metric_Location") FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: ALTER TABLE import.import_history_scans_1000015 ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6835; 0 17687 TABLE DATA import_history_scans_1000033 lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: ALTER TABLE import.import_history_scans_1000033 DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: COPY import.import_history_scans_1000033 (row_id, import_id, import_format_file_id, row_number, facility_id, department_id, process_id, process_code, shift_id, employee_id, customer_id, grouping_tier_option_id_1, item_id, scan_date, start_time, end_time, scan_minutes, isignore, ignore_reason) FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: ALTER TABLE import.import_history_scans_1000033 ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6837; 0 17695 TABLE DATA import_history_scans_1000040 lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: ALTER TABLE import.import_history_scans_1000040 DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: COPY import.import_history_scans_1000040 (row_id, import_id, import_format_file_id, row_number, facility_id, department_id, process_id, process_code, shift_id, employee_id, customer_id, grouping_tier_option_id_1, item_id, scan_date, start_time, end_time, scan_minutes, isignore, ignore_reason, "metric_Quantity", "metric_Locations", "metric_Pallets Shipped", "metric_Cartons Shipped", "metric_Putaway Required", "metric_Case Pallet ID", "metric_Return Type", "metric_Scan Size", "metric_Case/Pallet Changes") FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: ALTER TABLE import.import_history_scans_1000040 ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6839; 0 17703 TABLE DATA import_history_scans_1000043 lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: ALTER TABLE import.import_history_scans_1000043 DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: COPY import.import_history_scans_1000043 (row_id, import_id, import_format_file_id, row_number, facility_id, department_id, process_id, process_code, shift_id, employee_id, customer_id, grouping_tier_option_id_1, item_id, scan_date, start_time, end_time, scan_minutes, isignore, ignore_reason, "metric_Quantity", "metric_Eaches", "metric_Cases", "metric_Cartons", "metric_Pallets", "metric_Orders", "metric_Locations", "metric_LPs", "metric_GM Scans", "metric_LP - Bar Code", "metric_AGS Process", "metric_Loaded Trips", "metric_PT-Accel", "metric_PT-speed", "metric_PT-Decel", "metric_Load-Accel", "metric_Load-Speed", "metric_Load-Decel", "metric_Weight", "metric_Each Pick", "metric_Trip %", "metric_Lift %", "metric_Utilization %") FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: ALTER TABLE import.import_history_scans_1000043 ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6841; 0 17711 TABLE DATA import_history_scans_1000045 lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: ALTER TABLE import.import_history_scans_1000045 DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: COPY import.import_history_scans_1000045 (row_id, import_id, import_format_file_id, row_number, facility_id, department_id, process_id, process_code, shift_id, employee_id, customer_id, grouping_tier_option_id_1, item_id, scan_date, start_time, end_time, scan_minutes, isignore, ignore_reason, metric_lbconv, metric_ildct, metric_ildcto, metric_iltrqt, metric_iltrum, metric_illitm, metric_illocn, metric_hours) FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: ALTER TABLE import.import_history_scans_1000045 ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6843; 0 17719 TABLE DATA import_history_scans_1000048 lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: ALTER TABLE import.import_history_scans_1000048 DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: COPY import.import_history_scans_1000048 (row_id, import_id, import_format_file_id, row_number, facility_id, department_id, process_id, process_code, shift_id, employee_id, customer_id, grouping_tier_option_id_1, item_id, scan_date, start_time, end_time, scan_minutes, isignore, ignore_reason, "metric_PETCO_SKU", "metric_PACK_QTY", "metric_NBR_LINES", "metric_NBR_CASES", "metric_NBR_PALLETS", "metric_NBR_UNITS", "metric_NBR_TOTES", "metric_NBR_FLOOR_STACKED_CASES", "metric_NBR_CONTAINERS", "metric_QTY") FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "import" does not exist | |
| Command was: ALTER TABLE import.import_history_scans_1000048 ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6845; 0 17727 TABLE DATA _test_employee_hours lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public._test_employee_hours" does not exist | |
| Command was: ALTER TABLE public._test_employee_hours DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public._test_employee_hours" does not exist | |
| Command was: COPY public._test_employee_hours (employee_id, item_date, client_id, facility_id, daily_hours, daily_overtime, project_hours, effective_hours, timecard_hours, regular_hours, ot_hours_1, ot_hours_2, ot_hours_3, missing_time_factor, overtime_factor, facility_period_id, employee_archive_id, supervisor_employee_id, supervisor_employee_archive_id) FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public._test_employee_hours" does not exist | |
| Command was: ALTER TABLE public._test_employee_hours ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6846; 0 17733 TABLE DATA _tmp_departmentlist lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public._tmp_departmentlist" does not exist | |
| Command was: ALTER TABLE public._tmp_departmentlist DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public._tmp_departmentlist" does not exist | |
| Command was: COPY public._tmp_departmentlist (department_id) FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public._tmp_departmentlist" does not exist | |
| Command was: ALTER TABLE public._tmp_departmentlist ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6847; 0 17736 TABLE DATA _tmp_missing lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public._tmp_missing" does not exist | |
| Command was: ALTER TABLE public._tmp_missing DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public._tmp_missing" does not exist | |
| Command was: COPY public._tmp_missing (item_id) FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public._tmp_missing" does not exist | |
| Command was: ALTER TABLE public._tmp_missing ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6898; 0 18046 TABLE DATA country lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16542" is a system trigger | |
| Command was: ALTER TABLE public.country DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "country": ERROR: duplicate key value violates unique constraint "country_pkey" | |
| DETAIL: Key (country_code)=(PM) already exists. | |
| CONTEXT: COPY country, line 1 | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16542" is a system trigger | |
| Command was: ALTER TABLE public.country ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 7031; 0 18883 TABLE DATA region lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16567" is a system trigger | |
| Command was: ALTER TABLE public.region DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "region": ERROR: duplicate key value violates unique constraint "region_pkey" | |
| DETAIL: Key (country_code, region_code)=(US, PA) already exists. | |
| CONTEXT: COPY region, line 1 | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16567" is a system trigger | |
| Command was: ALTER TABLE public.region ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 7001; 0 18715 TABLE DATA location lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16587" is a system trigger | |
| Command was: ALTER TABLE public.location DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16587" is a system trigger | |
| Command was: ALTER TABLE public.location ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6911; 0 18127 TABLE DATA person lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16619" is a system trigger | |
| Command was: ALTER TABLE public.person DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16619" is a system trigger | |
| Command was: ALTER TABLE public.person ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6848; 0 17739 TABLE DATA account lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16640" is a system trigger | |
| Command was: ALTER TABLE public.account DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "account": ERROR: duplicate key value violates unique constraint "account_pkey" | |
| DETAIL: Key (account_id)=(0) already exists. | |
| CONTEXT: COPY account, line 535 | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16640" is a system trigger | |
| Command was: ALTER TABLE public.account ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6965; 0 18529 TABLE DATA groups lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16645" is a system trigger | |
| Command was: ALTER TABLE public.groups DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "groups": ERROR: duplicate key value violates unique constraint "group_pk" | |
| DETAIL: Key (group_name)=(System Administrators) already exists. | |
| CONTEXT: COPY groups, line 1 | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16645" is a system trigger | |
| Command was: ALTER TABLE public.groups ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6850; 0 17753 TABLE DATA account_group lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_16642" is a system trigger | |
| Command was: ALTER TABLE public.account_group DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "account_group": ERROR: duplicate key value violates unique constraint "account_group_pk" | |
| DETAIL: Key (account_name, group_name)=(admin, System Administrators) already exists. | |
| CONTEXT: COPY account_group, line 1 | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_16642" is a system trigger | |
| Command was: ALTER TABLE public.account_group ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 7081; 0 96352455 TABLE DATA account_login_history lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_19694" is a system trigger | |
| Command was: ALTER TABLE public.account_login_history DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "account_login_history": ERROR: insert or update on table "account_login_history" violates foreign key constraint "account_login_history_account_fk" | |
| DETAIL: Key (account_id)=(89) is not present in table "account". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_19694" is a system trigger | |
| Command was: ALTER TABLE public.account_login_history ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6851; 0 17756 TABLE DATA account_session lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_16882" is a system trigger | |
| Command was: ALTER TABLE public.account_session DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "account_session": ERROR: insert or update on table "account_session" violates foreign key constraint "account_session_account_id_fkey" | |
| DETAIL: Key (account_id)=(2158) is not present in table "account". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_16882" is a system trigger | |
| Command was: ALTER TABLE public.account_session ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6889; 0 17997 TABLE DATA client lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16818" is a system trigger | |
| Command was: ALTER TABLE public.client DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16818" is a system trigger | |
| Command was: ALTER TABLE public.client ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 7016; 0 18785 TABLE DATA period lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16839" is a system trigger | |
| Command was: ALTER TABLE public.period DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "period": ERROR: duplicate key value violates unique constraint "period_pk" | |
| DETAIL: Key (period_id)=(1) already exists. | |
| CONTEXT: COPY period, line 1 | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16839" is a system trigger | |
| Command was: ALTER TABLE public.period ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 7018; 0 18793 TABLE DATA period_start lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16865" is a system trigger | |
| Command was: ALTER TABLE public.period_start DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "period_start": ERROR: duplicate key value violates unique constraint "period_start_pk" | |
| DETAIL: Key (period_start_id)=(1) already exists. | |
| CONTEXT: COPY period_start, line 1 | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16865" is a system trigger | |
| Command was: ALTER TABLE public.period_start ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6942; 0 18397 TABLE DATA facility lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16971" is a system trigger | |
| Command was: ALTER TABLE public.facility DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: column "els_period_id" of relation "facility" does not exist | |
| Command was: COPY public.facility (facility_id, client_id, location_id, facility_name, isactive, created, updated, created_by, updated_by, els_period_id, els_period_start_id, els_period_referencedate, qls_period_id, qls_period_start_id, qls_period_referencedate, hascustomers, grading_els_lifetime_boundary, grading_report_memo, istracking, ismissinghours_els, isblend_hours, isshow_rankings, isindirect_item_bonus, timecard_start_offset, istimecard_clock_auto_lunch, timecard_clock_auto_lunch_threshold, timecard_clock_auto_lunch_length, isapply_employee_minimum_wage, missing_time_process_id) FROMstdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16971" is a system trigger | |
| Command was: ALTER TABLE public.facility ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6852; 0 17762 TABLE DATA analytics_project lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18845" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18845" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6999; 0 18705 TABLE DATA laborstandard lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17130" is a system trigger | |
| Command was: ALTER TABLE public.laborstandard DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "laborstandard": ERROR: duplicate key value violates unique constraint "laborstandard_pk" | |
| DETAIL: Key (laborstandard_id)=(1) already exists. | |
| CONTEXT: COPY laborstandard, line 1 | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17130" is a system trigger | |
| Command was: ALTER TABLE public.laborstandard ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6827; 0 17399 TABLE DATA department lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17222" is a system trigger | |
| Command was: ALTER TABLE public.department DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "department": ERROR: insert or update on table "department" violates foreign key constraint "department_facility_fk" | |
| DETAIL: Key (facility_id)=(18) is not present in table "facility". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17222" is a system trigger | |
| Command was: ALTER TABLE public.department ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 7021; 0 18812 TABLE DATA process lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17242" is a system trigger | |
| Command was: ALTER TABLE public.process DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: column "dependency_bonus_amount" of relation "process" does not exist | |
| Command was: COPY public.process (process_id, process_name, client_id, facility_id, department_id, goal_rate, issupervisor, supervisor_department_id, supervisor_shift_id, issupervisor_qls_fail, supervisor_qls_fail_threshold, isdependency, dependency_department_id, dependency_shift_id, dependency_process_id, dependency_bonus_amount, dependency_els_threshold, islaboralgorithm, metric1_name, metric1_value, ismetric1_mandatory, metric2_name, metric2_value, metric2_hasdependent, ismetric2_mandatory, metric3_name, metric3_value, ismetric3_mandatory, metric4_name, metric4_value, num_employees, isactive, created, updated, created_by, updated_by, process_description, dependency_facility_id, isbillable, isindirect, costing_metric, ismanual, ismetric1_costing, ismetric2_costing, ismetric3_costing, issupervisor_supervised_employees, supervisor_els_threshold_1, supervisor_els_threshold_2, supervisor_els_threshold_3, supervisor_els_bonus_amount_1, supervisor_els_bonus_amount_2, supervisor_els_bonus_amount_3, supervisor_indirect_threshold_1, supervisor_indirect_threshold_2, supervisor_indirect_threshold_3, supervisor_indirect_bonus_amount_1, supervisor_indirect_bonus_amount_2, supervisor_indirect_bonus_amount_3, dependency_els_threshold_1, dependency_els_threshold_2, dependency_els_threshold_3, dependency_els_bonus_amount_1, dependency_els_bonus_amount_2, dependency_els_bonus_amount_3, isbillable_budget, ismissing_time) FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17242" is a system trigger | |
| Command was: ALTER TABLE public.process ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6856; 0 17788 TABLE DATA analytics_project_process lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18868" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_process DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "analytics_project_process": ERROR: insert or update on table "analytics_project_process" violates foreign key constraint "analytics_project_process_process_fk" | |
| DETAIL: Key (process_id)=(2232) is not present in table "process". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18868" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_process ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6899; 0 18049 TABLE DATA customer lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17308" is a system trigger | |
| Command was: ALTER TABLE public.customer DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "customer": ERROR: insert or update on table "customer" violates foreign key constraint "customer_facility_fk" | |
| DETAIL: Key (facility_id)=(34) is not present in table "facility". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17308" is a system trigger | |
| Command was: ALTER TABLE public.customer ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6854; 0 17772 TABLE DATA analytics_project_customer_process_metric lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18924" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_customer_process_metric DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "analytics_project_customer_process_metric": ERROR: insert or update on table "analytics_project_customer_process_metric" violates foreign key constraint "analytics_project_customer_process_metric_customer_fk" | |
| DETAIL: Key (customer_id)=(1150) is not present in table "customer". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18924" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_customer_process_metric ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6861; 0 17832 TABLE DATA analytics_project_process_result lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18941" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_process_result DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "analytics_project_process_result": ERROR: insert or update on table "analytics_project_process_result" violates foreign key constraint "analytics_project_process_result_analytics_project_process_fk" | |
| DETAIL: Key (analytics_project_id, process_id)=(4, 1695) is not present in table "analytics_project_process". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18941" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_process_result ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6855; 0 17782 TABLE DATA analytics_project_customer_process_result lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18943" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_customer_process_result DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "analytics_project_customer_process_result": ERROR: insert or update on table "analytics_project_customer_process_result" violates foreign key constraint "analytics_project_customer_process_result_analytics_project_pro" | |
| DETAIL: Key (analytics_project_id, process_id)=(111, 4124) is not present in table "analytics_project_process_result". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18943" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_customer_process_result ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 7043; 0 19017 TABLE DATA shift lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17363" is a system trigger | |
| Command was: ALTER TABLE public.shift DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "shift": ERROR: insert or update on table "shift" violates foreign key constraint "shift_facility_fk" | |
| DETAIL: Key (facility_id)=(25) is not present in table "facility". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17363" is a system trigger | |
| Command was: ALTER TABLE public.shift ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6823; 0 17335 TABLE DATA item lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17442" is a system trigger | |
| Command was: ALTER TABLE public.item DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "item": ERROR: relation "facility_period" does not exist | |
| LINE 2: FROM facility_period | |
| ^ | |
| QUERY: SELECT facility_period_id | |
| FROM facility_period | |
| WHERE client_id = NEW.client_id AND facility_id = NEW.facility_id | |
| AND NEW.item_date BETWEEN period_start AND period_end | |
| AND period_type = 'PAY' | |
| CONTEXT: PL/pgSQL function public.p_trigger_item() line 16 at SQL statement | |
| COPY item, line 1: "53196 111109CF ..." | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17442" is a system trigger | |
| Command was: ALTER TABLE public.item ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6857; 0 17800 TABLE DATA analytics_project_process_item_outlier lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18956" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_process_item_outlier DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "analytics_project_process_item_outlier": ERROR: insert or update on table "analytics_project_process_item_outlier" violates foreign key constraint "analytics_project_process_item_outlier_analytics_project_proces" | |
| DETAIL: Key (analytics_project_id, process_id)=(1, 1660) is not present in table "analytics_project_process". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18956" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_process_item_outlier ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6858; 0 17806 TABLE DATA analytics_project_process_item_result lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18975" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_process_item_result DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "analytics_project_process_item_result": ERROR: insert or update on table "analytics_project_process_item_result" violates foreign key constraint "analytics_project_process_item_result_analytics_project_process" | |
| DETAIL: Key (analytics_project_id, process_id)=(99, 3705) is not present in table "analytics_project_process". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18975" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_process_item_result ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 7024; 0 18847 TABLE DATA process_metric lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18873" is a system trigger | |
| Command was: ALTER TABLE public.process_metric DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "process_metric": ERROR: insert or update on table "process_metric" violates foreign key constraint"process_metric_process_fk" | |
| DETAIL: Key (process_id)=(2786) is not present in table "process". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18873" is a system trigger | |
| Command was: ALTER TABLE public.process_metric ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6859; 0 17812 TABLE DATA analytics_project_process_metric lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18870" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_process_metric DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "analytics_project_process_metric": ERROR: insert or update on table "analytics_project_process_metric" violates foreign key constraint "analytics_project_process_metric_analytics_project_process_fk" | |
| DETAIL: Key (analytics_project_id, process_id)=(96, 2885) is not present in table "analytics_project_process". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18870" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_process_metric ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6860; 0 17822 TABLE DATA analytics_project_process_note lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18893" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_process_note DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "analytics_project_process_note": ERROR: insert or update on table "analytics_project_process_note"violates foreign key constraint "analytics_project_process_note_analytics_project_process_fk" | |
| DETAIL: Key (analytics_project_id, process_id)=(125, 7469) is not present in table "analytics_project_process". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18893" is a system trigger | |
| Command was: ALTER TABLE public.analytics_project_process_note ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6865; 0 17857 TABLE DATA batchreport lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18719" is a system trigger | |
| Command was: ALTER TABLE public.batchreport DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "batchreport": ERROR: insert or update on table "batchreport" violates foreign key constraint "batchreport_facility_fk" | |
| DETAIL: Key (facility_id)=(25) is not present in table "facility". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18719" is a system trigger | |
| Command was: ALTER TABLE public.batchreport ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 7033; 0 18899 TABLE DATA report_category lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17780" is a system trigger | |
| Command was: ALTER TABLE public.report_category DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "report_category": ERROR: duplicate key value violates unique constraint "report_category_pk" | |
| DETAIL: Key (report_category_id)=(1) already exists. | |
| CONTEXT: COPY report_category, line 1 | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17780" is a system trigger | |
| Command was: ALTER TABLE public.report_category ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 7032; 0 18886 TABLE DATA report lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17790" is a system trigger | |
| Command was: ALTER TABLE public.report DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "report": ERROR: duplicate key value violates unique constraint "report_pk" | |
| DETAIL: Key (report_id)=(1) already exists. | |
| CONTEXT: COPY report, line 1 | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17790" is a system trigger | |
| Command was: ALTER TABLE public.report ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6867; 0 17865 TABLE DATA batchreport_report lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18736" is a system trigger | |
| Command was: ALTER TABLE public.batchreport_report DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "batchreport_report": ERROR: insert or update on table "batchreport_report" violates foreign key constraint "batchreport_report_batchreport_fk" | |
| DETAIL: Key (batchreport_id)=(6) is not present in table "batchreport". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18736" is a system trigger | |
| Command was: ALTER TABLE public.batchreport_report ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 7040; 0 18938 TABLE DATA report_parameter lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18741" is a system trigger | |
| Command was: ALTER TABLE public.report_parameter DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "report_parameter": ERROR: duplicate key value violates unique constraint "report_parameter_pk" | |
| DETAIL: Key (report_parameter_id)=(5501) already exists. | |
| CONTEXT: COPY report_parameter, line 1 | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18741" is a system trigger | |
| Command was: ALTER TABLE public.report_parameter ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6869; 0 17870 TABLE DATA batchreport_report_parameter lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18738" is a system trigger | |
| Command was: ALTER TABLE public.batchreport_report_parameter DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "batchreport_report_parameter": ERROR: insert or update on table "batchreport_report_parameter" violates foreign key constraint "batchreport_report_parameter_batchreport_report_fk" | |
| DETAIL: Key (batchreport_report_id)=(67) is not present in table "batchreport_report". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18738" is a system trigger | |
| Command was: ALTER TABLE public.batchreport_report_parameter ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6871; 0 17878 TABLE DATA batchreport_result lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18760" is a system trigger | |
| Command was: ALTER TABLE public.batchreport_result DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "batchreport_result": ERROR: insert or update on table "batchreport_result" violates foreign key constraint "batchreport_result_facility_fk" | |
| DETAIL: Key (facility_id)=(143) is not present in table "facility". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18760" is a system trigger | |
| Command was: ALTER TABLE public.batchreport_result ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6873; 0 17886 TABLE DATA blended_hours_queue lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.blended_hours_queue" does not exist | |
| Command was: ALTER TABLE public.blended_hours_queue DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.blended_hours_queue" does not exist | |
| Command was: COPY public.blended_hours_queue (client_id, facility_id, item_date, queue_time) FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.blended_hours_queue" does not exist | |
| Command was: ALTER TABLE public.blended_hours_queue ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6874; 0 17895 TABLE DATA budget lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_19152" is a system trigger | |
| Command was: ALTER TABLE public.budget DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "budget": ERROR: insert or update on table "budget" violates foreign key constraint "budget_facility_fk" | |
| DETAIL: Key (facility_id)=(53) is not present in table "facility". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_19152" is a system trigger | |
| Command was: ALTER TABLE public.budget ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6876; 0 17910 TABLE DATA budget_interval_payroll lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_19188" is a system trigger | |
| Command was: ALTER TABLE public.budget_interval_payroll DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: column "indirect_percent" of relation "budget_interval_payroll" does not exist | |
| Command was: COPY public.budget_interval_payroll (budget_interval_payroll_id, budget_id, budget_interval_number, work_days, overtime, average_wage, created, updated, created_by, updated_by, indirect_percent) FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_19188" is a system trigger | |
| Command was: ALTER TABLE public.budget_interval_payroll ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6878; 0 17924 TABLE DATA budget_interval_process_hours lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_19435" is a system trigger | |
| Command was: ALTER TABLE public.budget_interval_process_hours DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "budget_interval_process_hours": ERROR: insert or update on table "budget_interval_process_hours" violates foreign key constraint "budget_interval_process_hours_budget_fk" | |
| DETAIL: Key (budget_id)=(10) is not present in table "budget". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_19435" is a system trigger | |
| Command was: ALTER TABLE public.budget_interval_process_hours ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6880; 0 17937 TABLE DATA budget_interval_process_uph lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_19401" is a system trigger | |
| Command was: ALTER TABLE public.budget_interval_process_uph DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "budget_interval_process_uph": ERROR: insert or update on table "budget_interval_process_uph" violates foreign key constraint "budget_interval_process_uph_budget_fk" | |
| DETAIL: Key (budget_id)=(7) is not present in table "budget". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_19401" is a system trigger | |
| Command was: ALTER TABLE public.budget_interval_process_uph ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6882; 0 17950 TABLE DATA budget_interval_volume lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_19236" is a system trigger | |
| Command was: ALTER TABLE public.budget_interval_volume DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "budget_interval_volume": ERROR: insert or update on table "budget_interval_volume" violates foreign key constraint "budget_interval_volume_budget_fk" | |
| DETAIL: Key (budget_id)=(3) is not present in table "budget". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_19236" is a system trigger | |
| Command was: ALTER TABLE public.budget_interval_volume ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6884; 0 17963 TABLE DATA budget_interval_volume_process lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_19238" is a system trigger | |
| Command was: ALTER TABLE public.budget_interval_volume_process DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "budget_interval_volume_process": ERROR: insert or update on table "budget_interval_volume_process"violates foreign key constraint "budget_interval_volume_process_budget_interval_volume_fk" | |
| DETAIL: Key (budget_interval_volume_id)=(1) is not present in table "budget_interval_volume". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_19238" is a system trigger | |
| Command was: ALTER TABLE public.budget_interval_volume_process ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6886; 0 17975 TABLE DATA budget_metric_ratio lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_19154" is a system trigger | |
| Command was: ALTER TABLE public.budget_metric_ratio DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "budget_metric_ratio": ERROR: insert or update on table "budget_metric_ratio" violates foreign key constraint "budget_metric_ratio_budget_fk" | |
| DETAIL: Key (budget_id)=(7) is not present in table "budget". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_19154" is a system trigger | |
| Command was: ALTER TABLE public.budget_metric_ratio ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6890; 0 18006 TABLE DATA client_account lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_17054" is a system trigger | |
| Command was: ALTER TABLE public.client_account DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "client_account": ERROR: insert or update on table "client_account" violates foreign key constraint"client_account_account_fk" | |
| DETAIL: Key (account_id)=(1) is not present in table "account". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_17054" is a system trigger | |
| Command was: ALTER TABLE public.client_account ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6892; 0 18011 TABLE DATA client_map lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.client_map" does not exist | |
| Command was: ALTER TABLE public.client_map DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.client_map" does not exist | |
| Command was: COPY public.client_map (client_id, ad_client_id) FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.client_map" does not exist | |
| Command was: ALTER TABLE public.client_map ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 7060; 0 5850362 TABLE DATA easymetrics_module lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16823" is a system trigger | |
| Command was: ALTER TABLE public.easymetrics_module DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "easymetrics_module": ERROR: duplicate key value violates unique constraint "easymetrics_module_pk" | |
| DETAIL: Key (module_name)=(em) already exists. | |
| CONTEXT: COPY easymetrics_module, line 1 | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_16823" is a system trigger | |
| Command was: ALTER TABLE public.easymetrics_module ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 7061; 0 5850370 TABLE DATA client_module lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_16820" is a system trigger | |
| Command was: ALTER TABLE public.client_module DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_16820" is a system trigger | |
| Command was: ALTER TABLE public.client_module ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 7050; 0 19089 TABLE DATA system lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18510" is a system trigger | |
| Command was: ALTER TABLE public.system DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "system": ERROR: duplicate key value violates unique constraint "system_pkey" | |
| DETAIL: Key (system_id)=(2) already exists. | |
| CONTEXT: COPY system, line 1 | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18510" is a system trigger | |
| Command was: ALTER TABLE public.system ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6893; 0 18014 TABLE DATA client_system lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18569" is a system trigger | |
| Command was: ALTER TABLE public.client_system DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "client_system": ERROR: insert or update on table "client_system" violates foreign key constraint "client_system_system_fk" | |
| DETAIL: Key (system_id)=(5100) is not present in table "system". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18569" is a system trigger | |
| Command was: ALTER TABLE public.client_system ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6895; 0 18027 TABLE DATA client_system_identifier lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18566" is a system trigger | |
| Command was: ALTER TABLE public.client_system_identifier DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "client_system_identifier": ERROR: insert or update on table "client_system_identifier" violates foreign key constraint "client_system_identifier_client_system_fk" | |
| DETAIL: Key (client_system_id)=(2504) is not present in table "client_system". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18566" is a system trigger | |
| Command was: ALTER TABLE public.client_system_identifier ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6973; 0 18573 TABLE DATA import_format lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18393" is a system trigger | |
| Command was: ALTER TABLE public.import_format DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "import_format": ERROR: duplicate key value violates unique constraint "import_format_pkey" | |
| DETAIL: Key (import_format_id)=(1) already exists. | |
| CONTEXT: COPY import_format, line 1 | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_18393" is a system trigger | |
| Command was: ALTER TABLE public.import_format ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6897; 0 18040 TABLE DATA client_system_import_format lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.client_system_import_format" does not exist | |
| Command was: ALTER TABLE public.client_system_import_format DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.client_system_import_format" does not exist | |
| Command was: COPY public.client_system_import_format (client_system_id, import_format_id, custom_client_parser_class, custom_client_formatter_class) FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.client_system_import_format" does not exist | |
| Command was: ALTER TABLE public.client_system_import_format ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6900; 0 18057 TABLE DATA customer_archive lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18097" is a system trigger | |
| Command was: ALTER TABLE public.customer_archive DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "customer_archive": ERROR: insert or update on table "customer_archive" violates foreign key constraint "customer_archive_facility_fk" | |
| DETAIL: Key (facility_id)=(34) is not present in table "facility". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18097" is a system trigger | |
| Command was: ALTER TABLE public.customer_archive ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6903; 0 18066 TABLE DATA customer_process lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_17295" is a system trigger | |
| Command was: ALTER TABLE public.customer_process DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "customer_process": ERROR: insert or update on table "customer_process" violates foreign key constraint "customer_process_facility_fk" | |
| DETAIL: Key (facility_id)=(46) is not present in table "facility". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_17295" is a system trigger | |
| Command was: ALTER TABLE public.customer_process ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6904; 0 18074 TABLE DATA customer_process_metric lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_19353" is a system trigger | |
| Command was: ALTER TABLE public.customer_process_metric DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "customer_process_metric": ERROR: insert or update on table "customer_process_metric" violates foreign key constraint "customer_process_metric_process_fk" | |
| DETAIL: Key (process_id)=(5031) is not present in table "process". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_19353" is a system trigger | |
| Command was: ALTER TABLE public.customer_process_metric ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6905; 0 18085 TABLE DATA customer_process_metric_archive lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_19355" is a system trigger | |
| Command was: ALTER TABLE public.customer_process_metric_archive DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "customer_process_metric_archive": ERROR: insert or update on table "customer_process_metric_archive" violates foreign key constraint "customer_process_metric_archive_customer_process_metric_fk" | |
| DETAIL: Key (customer_process_metric_id)=(2) is not present in table "customer_process_metric". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_19355" is a system trigger | |
| Command was: ALTER TABLE public.customer_process_metric_archive ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6821; 0 17308 TABLE DATA department_archive lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18005" is a system trigger | |
| Command was: ALTER TABLE public.department_archive DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "department_archive": ERROR: insert or update on table "department_archive" violates foreign key constraint "department_archive_facility_fk" | |
| DETAIL: Key (facility_id)=(19) is not present in table "facility". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18005" is a system trigger | |
| Command was: ALTER TABLE public.department_archive ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6917; 0 18209 TABLE DATA department_map lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.department_map" does not exist | |
| Command was: ALTER TABLE public.department_map DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.department_map" does not exist | |
| Command was: COPY public.department_map (department_id, al_department_id) FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.department_map" does not exist | |
| Command was: ALTER TABLE public.department_map ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6918; 0 18212 TABLE DATA department_period lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.department_period" does not exist | |
| Command was: ALTER TABLE public.department_period DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.department_period" does not exist | |
| Command was: COPY public.department_period (department_period_id, department_archive_id, client_id, facility_id, department_id, period_start, period_type, period_id, period_start_id, period_referencedate, period_end, iscalculation_required, calculation_date, created) FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.department_period" does not exist | |
| Command was: ALTER TABLE public.department_period ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6948; 0 18442 TABLE DATA facility_period_config lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17353" is a system trigger | |
| Command was: ALTER TABLE public.facility_period_config DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "facility_period_config": ERROR: insert or update on table "facility_period_config" violates foreign key constraint "facility_period_config_facility_fk" | |
| DETAIL: Key (facility_id)=(24) is not present in table "facility". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17353" is a system trigger | |
| Command was: ALTER TABLE public.facility_period_config ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6927; 0 18302 TABLE DATA employee lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17452" is a system trigger | |
| Command was: ALTER TABLE public.employee DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "employee": ERROR: relation "department" does not exist | |
| LINE 1: SELECT MIN(base_wage) FROM department | |
| ^ | |
| QUERY: SELECT MIN(base_wage) FROM department | |
| WHERE client_id = NEW.client_id | |
| AND facility_id = NEW.facility_id | |
| AND base_wage > 0 | |
| AND isactive | |
| CONTEXT: PL/pgSQL function public.p_trigger_employee() line 8 at SQL statement | |
| COPY employee, line 66: "2406 1000012 14 \N 2423 Standard \N \N t 2009-04-30 00:21:45+00 2010-04-07 08:09:01.785741+00 0 0 10..." | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_17452" is a system trigger | |
| Command was: ALTER TABLE public.employee ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6822; 0 17317 TABLE DATA employee_archive lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18058" is a system trigger | |
| Command was: ALTER TABLE public.employee_archive DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] COPY failed for table "employee_archive": ERROR: insert or update on table "employee_archive" violates foreign key constraint "employee_archive_employee_fk" | |
| DETAIL: Key (employee_id)=(2899) is not present in table "employee". | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18058" is a system trigger | |
| Command was: ALTER TABLE public.employee_archive ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 6826; 0 17389 TABLE DATA employee_hours lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18166" is a system trigger | |
| Command was: ALTER TABLE public.employee_hours DISABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: column "updated" of relation "employee_hours" does not exist | |
| Command was: COPY public.employee_hours (employee_id, item_date, client_id, facility_id, daily_hours, daily_overtime, project_hours, effective_hours, timecard_hours, regular_hours, ot_hours_1, ot_hours_2, ot_hours_3, missing_time_factor, overtime_factor, facility_period_id, employee_archive_id, supervisor_employee_id, supervisor_employee_archive_id, missing_hours, els_value, els_hours, updated) FROM stdin; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_18166" is a system trigger | |
| Command was: ALTER TABLE public.employee_hours ENABLE TRIGGER ALL; | |
| pg_restore: [archiver (db)] Error from TOC entry 7073; 0 27082436 TABLE DATA employee_earnings lp | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_c_19600" is a system trigger | |
| Command was: ALTER TABLE public.employee_earnings DISABLE TRIGGER ALL; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment