Re: [BUGS] PG8.4.7: updating rows leaves duplicate rows violating PK

2011-08-17 Thread Pavel Stehule
2011/8/17 Rainer Pruy : > Hallo, > this is strange for sure. The database is in heavy use regularly. > So it is - if at all - a rare occurrence. > > The update statement reported 346305 updated rows. > And I could verify that this is the number of rows that hat there value > change > (where afterwa

Re: [BUGS] PG8.4.7: updating rows leaves duplicate rows violating PK

2011-08-17 Thread Rainer Pruy
Hallo, this is strange for sure. The database is in heavy use regularly. So it is - if at all - a rare occurrence. The update statement reported 346305 updated rows. And I could verify that this is the number of rows that hat there value change (where afterwards there was a "new" version in the ta

Re: [BUGS] PG8.4.7: updating rows leaves duplicate rows violating PK

2011-08-17 Thread Pavel Stehule
Hello 2011/8/17 Rainer Pruy : > This is strange and as of now I do not have a reliable way of reproducing. > Nevertheless, > either there is a major blunder on my side that urgently needs being > pointed at and eliminated > or there is something really strange with PG. > > Short version: > > I upd

[BUGS] PG8.4.7: updating rows leaves duplicate rows violating PK

2011-08-17 Thread Rainer Pruy
This is strange and as of now I do not have a reliable way of reproducing. Nevertheless, either there is a major blunder on my side that urgently needs being pointed at and eliminated or there is something really strange with PG. Short version: I update some rows of a table changing non-primary k