duplicated rows on update when client dies

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема duplicated rows on update when client dies
Дата
Msg-id 200008251928.e7PJSs345566@hub.org
обсуждение исходный текст
Список pgsql-bugs
Richard Gonda (zigur@matavnet.hu) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
duplicated rows on update when client dies

Long Description
We expected if a network client dies in update proceess (in case example power off), duplicated rows remained in
database,the old and updated rows too. it will be work, but on vacuum it cause bug on uniquie keys. Another strange
expectingafter crash : deleting. for example DELETE FROM table WHERE prim_code > 10 -> 80 DELETED. Again this delete
command,120 DELETED.. and again. We expected only on network client this, never on locally connnected client. 

Sample Code


No file was uploaded with this report

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

Предыдущее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: wrong permissions for triggers invoked by rewrite rules
Следующее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Any user able to connect to a database can create tables/etc