Re: order of row processing affects updates

Поиск
Список
Период
Сортировка
От Marius Andreiana
Тема Re: order of row processing affects updates
Дата
Msg-id 1095603078.2896.21.camel@marte.biciclete.ro
обсуждение исходный текст
Ответ на order of row processing affects updates  (Paramveer.Singh@trilogy.com)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Paramveer.Singh@trilogy.com
Дата:
Сообщение: order of row processing affects updates
Следующее
От: Soeren Gerlach
Дата:
Сообщение: Problem in converting int to timestamp value - why?