Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Avoiding any locks in SQL Servers - read and understand....its magic.

Re: Avoiding any locks in SQL Servers - read and understand....its magic.

From: Christopher Browne <cbbrowne_at_acm.org>
Date: 26 Jan 2004 19:52:39 GMT
Message-ID: <bv3r66$n642e$1@ID-125932.news.uni-berlin.de>


After a long battle with technology, boston103_at_hotmail.com (VC), an earthling, wrote:
> I see you've conveniently excised the update statement I supplied.
> The constraint is right there, in the statement itself:
>
> update t1 set amount=amount-80
> where (select t1.amount+t2.amount from t1 join t2 on t1.id=t2.id) > 0;
>
> However, it's not honored by Oracle in the SERIALIZABLE IL.

SQL has a keyword for expressing constraints, called CONSTRAINT; you have "conveniently" chosen not to use it. You have instead set up a query that is NOT a "constraint."

-- 
wm(X,Y):-write(X),write('@'),write(Y). wm('aa454','freenet.carleton.ca').
http://cbbrowne.com/info/sgml.html
REALITY is a mescaline deficiency.
Received on Mon Jan 26 2004 - 13:52:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US