On Sun, 2004-09-19 at 08:37 -0500, Paramveer(dot)Singh(at)trilogy(dot)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