Is there a way to systematically check if a view is valid or invalid? In Oracle I've used the STATUS column in the ALL_OBJECTS system table to determine this. I can't find a similar column in Vertica.
Code: Select all
dbadmin=> create table test (id int, name varchar(10));
CREATE TABLE
dbadmin=> create view test_view as select * from test;
CREATE VIEW
dbadmin=> select * from test_view;
id | name
----+------
1 | Me
(1 row)
dbadmin=> drop table test;
DROP TABLE
dbadmin=> select * from test_view;
ERROR 4568: Relation "public.test" does not exist