Thomas F. O'Connell wrote: > 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... >
8.1 will use _shared_ row locks for such cases. -- Bruce Momjian | http://candle.pha.pa.us [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
