Skip site navigation (1) Skip section navigation (2)

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

From: "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: ROW SHARE/SELECT ... FOR UPDATE + foreign keys
Date: 2005-07-21 19:47:40
Message-ID: (view raw or whole thread)
Lists: 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  

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


pgsql-docs by date

Next:From: Thomas F. O'ConnellDate: 2005-07-21 20:32:28
Subject: Beta Docs
Previous:From: Halley Pacheco de OliveiraDate: 2005-07-17 12:04:25
Subject: PostgreSQL 8.0.3 Documentation - Chapter 21. Routine Database Maintenance Tasks

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group