• Noah Misch's avatar
    Switch user ID to the object owner when populating a materialized view. · f3ab5d46
    Noah Misch authored
    This makes superuser-issued REFRESH MATERIALIZED VIEW safe regardless of
    the object's provenance.  REINDEX is an earlier example of this pattern.
    As a downside, functions called from materialized views must tolerate
    running in a security-restricted operation.  CREATE MATERIALIZED VIEW
    need not change user ID.  Nonetheless, avoid creation of materialized
    views that will invariably fail REFRESH by making it, too, start a
    security-restricted operation.
    
    Back-patch to 9.3 so materialized views have this from the beginning.
    
    Reviewed by Kevin Grittner.
    f3ab5d46
create_materialized_view.sgml 4.9 KB