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™ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 |
- [DOCS] ROW SHARE/SELECT ... FOR UPDATE + foreign keys Thomas F. O'Connell
- Re: [DOCS] ROW SHARE/SELECT ... FOR UPDATE + fore... Bruce Momjian
