Question 113812 in PostgreSQL Question posted in
The official documentation can be found here.

PostgreSQL Views are disappearing

We created several views postgresql 12 (not materialized views) which include nested queries and multiple joins.
we are facing a strange behavior, are noticing that some views are disappearing from the view list and others are remaining. is this related to Database configuration.

Are we missing some configuration?

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    We didn't drop the tables directly, however since we are using ESRI ArcGIS Desktop to manage our GIS data which is hosted on a PostgreSQL database. we identified the cause of the issue after the admin replaced all the tables in the schema. and ArcGIS Desktop dropped the tables and deleting the views without informing the admin.


  2. 0

    I can only guess, but the one way that views can disappear is if you DROP them. You’d probably remember if you dropped them directly, but you can drop them indirectly with

    DROP TABLE some_table CASCADE;

    If you do that, all views and materialized views that depend on that table are dropped as well.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search