Thread: duplicated rows on update when client dies

duplicated rows on update when client dies

From
pgsql-bugs@postgresql.org
Date:
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