duplicated rows on update when client dies - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject duplicated rows on update when client dies
Date
Msg-id 200008251928.e7PJSs345566@hub.org
Whole thread Raw
List 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 by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: wrong permissions for triggers invoked by rewrite rules
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Any user able to connect to a database can create tables/etc