ROW SHARE/SELECT ... FOR UPDATE + foreign keys

Поиск
Список
Период
Сортировка
От Thomas F. O'Connell
Тема ROW SHARE/SELECT ... FOR UPDATE + foreign keys
Дата
Msg-id 7B27AD9D-67FC-47BE-9956-B4066E6B9C53@sitening.com
обсуждение исходный текст
Ответы Re: ROW SHARE/SELECT ... FOR UPDATE + foreign keys
Список pgsql-docs
What would people think of adding a note to the ROW SHARE section of Table-Level Locks remarking on the fact that referential integrity checks expressed through foreign keys do SELECT ... FOR UPDATES.


It was somewhat challenging today to try to track down a pervasive locking issue related to a table not directly referenced in a stored procedure but that was referenced by a key in a table that was being updated.

I'm not sure how this changes with the new shared row locking implementation in 8.1...

--

Thomas F. O'Connell

Co-Founder, Information Architect

Sitening, LLC


Strategic Open Source: Open Your i™


http://www.sitening.com/

110 30th Avenue North, Suite 6

Nashville, TN 37203-6320

615-260-0005


В списке pgsql-docs по дате отправления: