On Sun, 2004-09-19 at 08:37 -0500, [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
