Re: Weird lock or bug maybe?

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(at)ugnn(dot)ru