Martin Marques wrote:
> On Sun, 23 Jul 2006, Alvaro Herrera wrote:
>
> > Martin Marques escribió:
> >>
> >> After the SELECT FOR UPDATE other transactions can still see the locked
> >> rows. I want a read/write lock, so no one can access does rows.
> >
> > SELECT FOR UPDATE acquires an exclusive l
On Sun, 23 Jul 2006, Alvaro Herrera wrote:
Martin Marques escribió:
After the SELECT FOR UPDATE other transactions can still see the locked
rows. I want a read/write lock, so no one can access does rows.
SELECT FOR UPDATE acquires an exclusive lock, but other transactions
must try to acquire
Martin Marques escribió:
> On Sat, 22 Jul 2006, Alvaro Herrera wrote:
>
> >Martin Marques escribió:
> >>Is it posible to get an exclusive (read/write) lock on certain rows? I
> >>don't want to block the whole table, only certain rows, but I want it to
> >>be a read/write lock.
> >
> >That's what S
* Martin Marques:
>> That's what SELECT FOR UPDATE does.
>
> Hi Alvaro,
>
> After the SELECT FOR UPDATE other transactions can still see the
> locked rows. I want a read/write lock, so no one can access does rows.
You should probably run the other transactions at SERIALIZABLE level.
I suppose thi
On Sat, 22 Jul 2006, Alvaro Herrera wrote:
Martin Marques escribió:
Is it posible to get an exclusive (read/write) lock on certain rows? I
don't want to block the whole table, only certain rows, but I want it to
be a read/write lock.
That's what SELECT FOR UPDATE does.
Hi Alvaro,
After the
Martin Marques escribió:
> Is it posible to get an exclusive (read/write) lock on certain rows? I
> don't want to block the whole table, only certain rows, but I want it to
> be a read/write lock.
That's what SELECT FOR UPDATE does.
> AFAIK SELECT FOR UPDATE doesn't help with this.
Why?
--
A
Is it posible to get an exclusive (read/write) lock on certain rows? I
don't want to block the whole table, only certain rows, but I want it to
be a read/write lock.
AFAIK SELECT FOR UPDATE doesn't help with this.
Do I have to go for another aproche?
--
21:50:04 up 2 days, 9:07, 0 users,
