RECOMPILE_VIEW

RECOMPILE_VIEW(<view name>) is a function that can recreate a view that has been invalidated due to a schema change.

Permissions

The role must have the DDL permission at the database level, as well as SELECT permissions for any tables referenced by the view.

Syntax

recompile_view_statement ::=
    SELECT RECOMPILE_VIEW('[schema_name].view_name')
    ;

schema_name ::= identifier

view_name ::= identifier

Parameters

Parameter

Description

schema_name

The name of the schema the view is in.

view_name

The name of the view.

Examples

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