[DOCS] ROW SHARE/SELECT ... FOR UPDATE + foreign keys
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-TABLESIt 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
[DOCS] Beta Docs
There used to be a link to a built development version of the docs on the old developer site. Anyone know where that has gone?It's still mentioned at techdocs, but I don't see it in the Beta section of the website. -- 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
Re: [DOCS] Beta Docs
On Thu, Jul 21, 2005 at 03:32:28PM -0500, Thomas F. O'Connell wrote: > > There used to be a link to a built development version of the docs on > the old developer site. Anyone know where that has gone? >From http://www.postgresql.org/ the link is under Developers -> Testing. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [DOCS] Beta Docs
That's funny. I went straight to Beta Information and completely bypassed Testing... :) Thanks! -- 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 On Jul 21, 2005, at 3:45 PM, Michael Fuhr wrote: On Thu, Jul 21, 2005 at 03:32:28PM -0500, Thomas F. O'Connell wrote: From http://www.postgresql.org/ the link is under Developers -> Testing. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [DOCS] ROW SHARE/SELECT ... FOR UPDATE + foreign keys
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
