I think what prompted the lock to be AccessShareLock for the child rel
in the first place is the fact that ATExecDropInherit() (ALTER TABLE NO
INHERIT) uses AccessShare for the *parent* relation.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services