Lock while delete a table
От
Sergio Sinuco
Тема
Lock while delete a table
Дата
Msg-id
CAHn1vgEBWKfbeVWhMQbo8WNcbkcmLZ1ZKK2L2a74fBjPmttPPQ@mail.gmail.com
Список
Дерево обсуждения
Lock while delete a table Sergio Sinuco <sergiosinuco@datatraffic.com.co>
Re: Lock while delete a table "Jean-Yves F. Barbier" <12ukwn@gmail.com>
Re: Lock while delete a table Tom Lane <tgl@sss.pgh.pa.us>
Re: Lock while delete a table Sergio Sinuco <sergiosinuco@datatraffic.com.co>
Hi guys. I have a table A with a foreign key that refers a table B. Next, I have a function F that updates some rows in B. When I delete table A, a deadlock occurs because the function and the process that delete the table A are waiting for an AccessExclusiveLock to relation B.
Why does a drop table need an AccessExclusiveLock in tables refered by the deleted table?
Thanks
Sergio Sinuco
Why does a drop table need an AccessExclusiveLock in tables refered by the deleted table?
Thanks
Sergio Sinuco
В списке pgsql-novice по дате отправления
