I have a table (african_primates_17) set up in PostGIS and I have a view (finalised) generated from that. The view is then added into QGIS 3. The simple idea was to overwrite the table by importing from an updated shapefile - and then expect the QGIS map to be miraculously updated also. However, that did not work. I get the following error
Error 2 Creation of data source "public"."african_primates_17" failed: ERROR: cannot drop table african_primates_17 because other objects depend on it DETAIL: view finalised depends on table african_primates_17 HINT: Use DROP ... CASCADE to drop the dependent objects too. CONTEXT: SQL statement "DROP TABLE IF EXISTS public.african_primates_17 RESTRICT" PL/pgSQL function dropgeometrytable(character varying,character varying,character varying) line 15 at EXECUTE
Can anyone explain my error please? I thought the whole principle of views was for updates to be automatically made.