Mathias LAURENT
>From: "Jim C. Nasby" <[EMAIL PROTECTED]>
>To: Mathias Laurent <[EMAIL PROTECTED]>
>CC: pgsql-admin@postgresql.org
>Subject: Re: [ADMIN] Problem with SELECT FOR UPDATE NOWAIT
>Date: Thu, 20 Apr 2006 17:47:38 -0500
>
>I think you're c
I think you're confused about what actually happened...
Session 1:
decibel=# select * from a;
i
---
1
(1 row)
decibel=# begin;
BEGIN
decibel=# select * from a for update nowait;
i
---
1
(1 row)
decibel=#
Session 2:
decibel=# select * from a for update nowait;
ERROR: could not obtain loc
Hello,
Veiled I have a small problem which I have solved in a way not very clean, I
would thus like to have your opinion. When I made with the process 1 :
Select * FROM myTable WHERE num=3 FOR UPDATE NOWAIT
And that I remade it with a process 2 before having do one "Commit" It
blocked me (un
