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  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Halley Pacheco de Oliveira
Дата:
Сообщение: PostgreSQL 8.0.3 Documentation - Chapter 21. Routine Database Maintenance Tasks
Следующее
От: "Thomas F. O'Connell"
Дата:
Сообщение: Beta Docs