What lock mode does DROP POLICY take in PostgreSQL?

DROP POLICY takes a ACCESS EXCLUSIVE lock. Removes an RLS rule and can immediately expose or deny rows for the roles that rule covered.

Row-Level Security

`DROP POLICY`

Lock mode ACCESS EXCLUSIVE

Risk HIGH

Blocks reads, writes, other DDL

pgfence rule drop-policy

DROP POLICY orders_owner_read ON orders;

Removes an RLS rule and can immediately expose or deny rows for the roles that rule covered.