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: 7B27AD9D-67FC-47BE-9956-B4066E6B9C53@sitening.com (view raw or flat)
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.

http://www.postgresql.org/docs/8.0/static/explicit- 
locking.html#LOCKING-TABLES

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

Responses

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-2014 The PostgreSQL Global Development Group