• Joe Conway's avatar
    Disallow converting a table to a view if row security is present. · d824e280
    Joe Conway authored
    When DefineQueryRewrite() is about to convert a table to a view, it checks
    the table for features unavailable to views.  For example, it rejects tables
    having triggers.  It omits to reject tables having relrowsecurity or a
    pg_policy record. Fix that. To faciliate the repair, invent
    relation_has_policies() which indicates the presence of policies on a
    relation even when row security is disabled for that relation.
    
    Reported by Noah Misch. Patch by me, review by Stephen Frost. Back-patch
    to 9.5 where RLS was introduced.
    d824e280
rowsecurity.out 103 KB