RECOMPILE_VIEW(<view name>) is a function that can recreate a view that has been invalidated due to a schema change.
The role must have the
DDL permission at the database level, as well as
SELECT permissions for any tables referenced by the view.
recompile_view_statement ::= SELECT RECOMPILE_VIEW('[schema_name].view_name') ; schema_name ::= identifier view_name ::= identifier
||The name of the schema the view is in.|
||The name of the view.|
Recreating a view that has been invalidated¶
farm=> SELECT * FROM agressive_animals; View 'public.agressive_animals' is invalid since it references a table that has been dropped/altered. The probable candidates are: [ "public.cool_animals" ] farm=> SELECT recompile_view('only_agressive_animals'); executed