Thread

duplicated rows on update when client dies

PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2000-08-25T19:28:54Z

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 expecting after 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