If I do :
Session 1:
decibel=# begin;
BEGIN
decibel=# select * from i where i=1 for update nowait;
i
---
1
(1 row)
decibel=# begin;
BEGIN
decibel=# select * from i where i=2 for update nowait;
i
---
2
(1 row)
Session 2 :
decibel=# select * from i where i=1 for update nowait;
ERROR: could not o
ot refreshed for the first column, the value for col1 is 0.
Although insertion in the base worked and the serial have the good value
!!! And this code works perfectly for MySql :(
If somebody knows when that can come from ?
Thank y
blocked me (until there normal)
But once that I free by doing one "Commit" with process 1 All the table
remains to block for process 2...
To have access it, it is necessary that I do one "Commit" with the
processus2 !! It's very stran