Обсуждение: DROP TRIGGER lock

Поиск
Список
Период
Сортировка

DROP TRIGGER lock

От
Dull Bananas
Дата:
On these pages, it should be mentioned that DROP TRIGGER acquires an ACCESS EXCLUSIVE lock:


Re: DROP TRIGGER lock

От
"Euler Taveira"
Дата:
On Fri, Jun 7, 2024, at 12:06 PM, Dull Bananas wrote:
On these pages, it should be mentioned that DROP TRIGGER acquires an ACCESS EXCLUSIVE lock:




If I would add such information it would be in the latter. AFAICS the former
provides some examples of SQL commands that take AccessExclusiveLock. If you
search for AccessExclusiveLock into src/backend/commands/* you will notice that
there are more commands that were not mentioned in the Table-Level Locks
section.

Feel free to propose a patch.


--
Euler Taveira
EDB   https://www.enterprisedb.com/