search

smnorris / bcfishobs

Reference BC Known Fish Observations to the Freshwater Atlas stream network
Apache License 2.0
6 stars 2 forks source link

cascade when dropping view #43

Closed smnorris closed 1 year ago

smnorris commented 1 year ago 
psycopg2.errors.DependentObjectsStillExist: cannot drop table whse_fish.fiss_fish_obsrvtn_pnt_sp because other objects depend on it
DETAIL:  materialized view bcfishpass.observations_vw depends on table whse_fish.fiss_fish_obsrvtn_pnt_sp
materialized view bcfishpass.freshwater_fish_habitat_accessibility_model_salmon_vw depends on materialized view bcfishpass.observations_vw
materialized view bcfishpass.freshwater_fish_habitat_accessibility_model_steelhead_vw depends on materialized view bcfishpass.observations_vw
materialized view bcfishpass.freshwater_fish_habitat_accessibility_model_observations_vw depends on materialized view bcfishpass.observations_vw
HINT:  Use DROP ... CASCADE to drop the dependent objects too.