The table grid.egon_mv_grid_district should be deleted using cascade in the function mv_grid_districts.define-mv-grid-districts.
[2023-06-27 13:46:48,826] {taskinstance.py:901} INFO - Executing <Task(MvGridDistricts (versioned)): mv_grid_districts.define-mv-grid-districts> on 2023-06-27T11:14:27.442405+00:00
[2023-06-27 13:46:48,835] {standard_task_runner.py:54} INFO - Started process 1486 to run task
[2023-06-27 13:46:48,895] {standard_task_runner.py:77} INFO - Running: ['airflow', 'run', 'powerd-status-quo-processing-pipeline', 'mv_grid_districts.define-mv-grid-districts', '2023-06-27T11:14:27.442405+00:00', '--job_id', '1204', '--pool', 'default_pool', '--raw', '-sd', 'DAGS_FOLDER/dags/pipeline_status_quo.py', '--cfg_path', '/tmp/tmpy7qmei7z']
[2023-06-27 13:46:48,896] {standard_task_runner.py:78} INFO - Job 1204: Subtask mv_grid_districts.define-mv-grid-districts
[2023-06-27 13:46:48,954] {logging_mixin.py:120} INFO - Running <TaskInstance: powerd-status-quo-processing-pipeline.mv_grid_districts.define-mv-grid-districts 2023-06-27T11:14:27.442405+00:00 [running]> on host at36
[2023-06-27 13:46:50,250] {taskinstance.py:1150} ERROR - (psycopg2.errors.DependentObjectsStillExist) cannot drop table grid.egon_mv_grid_district because other objects depend on it
DETAIL: constraint egon_ev_count_mv_grid_district_bus_id_fkey on table demand.egon_ev_count_mv_grid_district depends on table grid.egon_mv_grid_district
constraint egon_ev_mv_grid_district_bus_id_fkey on table demand.egon_ev_mv_grid_district depends on table grid.egon_mv_grid_district
HINT: Use DROP ... CASCADE to drop the dependent objects too.
The table grid.egon_mv_grid_district should be deleted using cascade in the function mv_grid_districts.define-mv-grid-districts.
[2023-06-27 13:46:48,826] {taskinstance.py:901} INFO - Executing <Task(MvGridDistricts (versioned)): mv_grid_districts.define-mv-grid-districts> on 2023-06-27T11:14:27.442405+00:00 [2023-06-27 13:46:48,835] {standard_task_runner.py:54} INFO - Started process 1486 to run task [2023-06-27 13:46:48,895] {standard_task_runner.py:77} INFO - Running: ['airflow', 'run', 'powerd-status-quo-processing-pipeline', 'mv_grid_districts.define-mv-grid-districts', '2023-06-27T11:14:27.442405+00:00', '--job_id', '1204', '--pool', 'default_pool', '--raw', '-sd', 'DAGS_FOLDER/dags/pipeline_status_quo.py', '--cfg_path', '/tmp/tmpy7qmei7z'] [2023-06-27 13:46:48,896] {standard_task_runner.py:78} INFO - Job 1204: Subtask mv_grid_districts.define-mv-grid-districts [2023-06-27 13:46:48,954] {logging_mixin.py:120} INFO - Running <TaskInstance: powerd-status-quo-processing-pipeline.mv_grid_districts.define-mv-grid-districts 2023-06-27T11:14:27.442405+00:00 [running]> on host at36 [2023-06-27 13:46:50,250] {taskinstance.py:1150} ERROR - (psycopg2.errors.DependentObjectsStillExist) cannot drop table grid.egon_mv_grid_district because other objects depend on it DETAIL: constraint egon_ev_count_mv_grid_district_bus_id_fkey on table demand.egon_ev_count_mv_grid_district depends on table grid.egon_mv_grid_district constraint egon_ev_mv_grid_district_bus_id_fkey on table demand.egon_ev_mv_grid_district depends on table grid.egon_mv_grid_district HINT: Use DROP ... CASCADE to drop the dependent objects too.