Hi there I have much problems with wierd locking too. I thing that it problem is connected with localisation - when i update a "problem" row (which have text fields) with any different text data in text fields - all locks dissapper. I hope this info can help to solve this bug (because in PG 7.2.3 i didnt saw this problems//) -- Thanks BNY> Hi All, BNY> I got 2 very simple tables, one hold few values and got a unique field BNY> to be used as identifier and the other table got a reference to that BNY> table (foreign key). BNY> At my last testing before the problem I inserted to each one of the BNY> tables about 1 million rows, for the process of inserting new BNY> information I begin a transaction, delete all the previous information, BNY> insert the new information and commit the transaction. BNY> So far it never gave me any problems (though its the first time that I BNY> let a foreign key to exist) but now from some reason it "locks" a BNY> specific row from being deleted.... for example: BNY> If ill query: DELETE FROM table1; it will just get stuck... BNY> If ill try: DELETE FROM table1 WHERE table1_id=1523; it will work in BNY> most cases but for some rows it will just get stuck! BNY> Anyone know anything about this weird problem? BNY> By the way when I restarted the DB server I was able to delete the BNY> current row which stucked the process but then I got stuck at some other BNY> row at the table.... BNY> Thanks in advance, BNY> Ben-Nes Yonatan BNY> ---------------------------(end of broadcast)--------------------------- BNY> TIP 9: In versions below 8.0, the planner will ignore your desire to BNY> choose an index scan if your joining column's datatypes do not BNY> match -- С уважением, Игорь mailto:go@xxxxxxx ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
