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

2011-08-17 Thread Rainer Pruy
lysis). Thus, I have events with two different instances of PG. Something being imported by plain DML operations? A strange idea by itself anyway. Still clueless... Rainer Am 17.08.2011 13:33, schrieb Pavel Stehule: > Hello > > 2011/8/17 Rainer Pruy : >> This is strange and as

[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

Re: [BUGS] BUG #5946: Long exclusive lock taken by vacuum (not full)

2011-03-28 Thread Rainer Pruy
Fascinating. No real idea. I just hit "reply to list" on a message from tom (probably a reply to a message from you?). So from earlier experience with such operations, I would not have expected to not show up as sender or from of the message. So yes it was me posting and I have no idea on what act

Re: [BUGS] BUG #5946: Long exclusive lock taken by vacuum (not full)

2011-03-28 Thread Rainer Pruy
I digged into my sent folder, and the outgoing message already dat the false headers. So probably my MUA (thunderbird) got confused on something and caused that blunder. Sorry for that Rainer Am 28.03.2011 16:05, schrieb Alvaro Herrera: > Rainer, any idea? Please see > http://archives.postgresql