Re: Delete of child-entry locks father-table

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 8 Dec 2006 16:59:27 -0800
Message-ID: <1165625967.047868.9250@16g2000cwy.googlegroups.com>

DA Morgan wrote:
> hasta_l3_at_hotmail.com wrote:
>
> > As I get it,
> > the OP wanted to manually lock in exclusive mode some
> > configuration (or definition or type) tables, to prevent concurrent
> > changes by two users - not a completely stupid idea, IMO.
>
> Couldn't that be accomplished simply with SELECT FOR UPDATE?
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

This particular thread is 25+ items long. It looks like your addition here doesn't show an understanding of the scenario posed by the OP. Received on Fri Dec 08 2006 - 18:59:27 CST