Joseph Shraibman <[EMAIL PROTECTED]> writes:
> But the locking isn't working properly. I do something that should
> cause 3 different threads to try and do that append, and the first one
> goes through properly, but the second two append to the result of the
> first on only, meaning that the thir
And I forgot to mention my version is:
PostgreSQL 7.0.1 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66
Joseph Shraibman wrote:
>
> I have a program that does this:
> BEGIN;
> SELECT mystring FROM mytable WHERE x = 3 AND y = 4 FOR UPDATE;
>
> UPDATE mytable SET mystring = '' WHERE x = 3 AN
I have a program that does this:
BEGIN;
SELECT mystring FROM mytable WHERE x = 3 AND y = 4 FOR UPDATE;
UPDATE mytable SET mystring = '' WHERE x = 3 AND y
= 4;
END;
But the locking isn't working properly. I do something that should
cause 3 different threads to try and do that append, and the fir