Update the base view in PostgresDB

Viewed 15

I have created a view in the below manner in PostgresDB

create or replace view GEO_VIEW
as
 SELECT street,
    st.latitude_val,
    st.longitude_Val,
    st.location_name,
    st.vendor
from st_stat_tbl st 
join lt_stat_tbl lt on st.st_id = lt.lt_id
;

The issue is that this view is used in the definition of various other views. Now, I need to update this view as below

create or replace view GEO_VIEW
as
 SELECT street,
    st.latitude_val,
    st.longitude_Val,
    st.loc_val as location_name,
    st.vendor
from st_stat_tbl st 
join lt_stat_tbl lt on st.st_id = lt.lt_id
;

I get the below error messages.

[Code: 0, SQL State: 2BP01]  ERROR: cannot drop view GEO_VIEW because other objects depend on it

Any idea how I can update this without having to recreate the underlying views.?

0 Answers
Related