ALTER POLICY etc locks

Started by PG Bug reporting formover 2 years ago1 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/sql-alterpolicy.html
Description:

Hi folks, just wanted to drop a documentation suggestion: we document that
e.g. ALTER TABLE acquires an ACCESS EXCLUSIVE lock most of the time, but
there's currently no documentation that shows that ALTER POLICY does the
same. This seems to apply to the other POLICY commands too. It makes sense
as a behaviour, but could probably use writing down for clarity!

Source reference:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/commands/policy.c;hb=HEAD#l363

Cheers,

Curtis