Justin Pryzby <pryzby@telsasoft.com> writes:
> On Thu, Mar 16, 2023 at 04:52:07PM -0400, Tom Lane wrote:
> It is possible to use <link linkend="sql-altertable"><command>ALTER
> TABLE ATTACH/DETACH PARTITION</command></link> to perform these
> operations with a weaker lock, thus reducing interference with
> concurrent operations on the partitioned table.
> Note that in order for DETACH+DROP to use a lower lock level, it has to be
> DETACH CONCURRENTLY. ATTACH is implicitly uses a lower lock level, but for
> DETACH it's only on request.
Right, but that's the sort of detail you should read on that command's man
page, we don't need to duplicate it in N other places.
regards, tom lane