Re: order of row processing affects updates

On Sun, 2004-09-19 at 08:37 -0500, Paramveer.Singh@trilogy.com wrote:
> table a (id int primary key)
> and a particular instance of it:
>       id
> ------------------------
>       5
>       6
> 
> now update a set id = id +1;
> fails if the executor processes row with 5 first.
> Basically what we would like to do would be something like doing constraint
> validations only at the end of execution of an update query, instead of
> after every row update.
does it fail even if it's in a 
BEGIN
UPDATE ..
COMMIT
?

-- 
Marius Andreiana
Galuna - Solutii Linux in Romania
http://www.galuna.ro