pgsql: Fix pg_blocking_pids() for relation extension locks.
pgsql: Fix pg_blocking_pids() for relation extension locks.
От:
Nathan Bossart <nathan@postgresql.org>
Дата:
Fix pg_blocking_pids() for relation extension locks. pg_blocking_pids() assumes that members of the same lock group never block each other, but that hasn't been true for relation extension locks since v13. This commit teaches the function to report lock group members as blockers for relation extension locks. Since parallel workers are reported with their leader's PID, the result may now include the blocked session's own PID. Oversight in commit 85f6b49c2c. Author: Bertrand Drouvot Reviewed-by: Chao Li Reviewed-by: Kirill Reshke Reviewed-by: Shihao Zhong Discussion: https://postgr.es/m/apTpV8h%2BCYHf%2B1PJ%40bdtpg Backpatch-through: 14 Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/af42a7a82fc008a0d1f781138156155291fe73b9 Modified Files -------------- doc/src/sgml/func.sgml | 21 ++++++++++++++------- src/backend/utils/adt/lockfuncs.c | 10 ++++++++-- 2 files changed, 22 insertions(+), 9 deletions(-)