Re: Predicate locking - Mailing list pgsql-hackers

From Nicolas Barbier
Subject Re: Predicate locking
Date
Msg-id BANLkTi=xd9H00DHvHfZZmvbrdXze=fqHnw@mail.gmail.com
Whole thread Raw
In response to Predicate locking  (Vlad Arkhipov <arhipov@dc.baikal.ru>)
Responses Re: Predicate locking  (Vlad Arkhipov <arhipov@dc.baikal.ru>)
List pgsql-hackers
2011/4/27 Vlad Arkhipov <arhipov@dc.baikal.ru>:

> I'm currently need predicate locking in the project, so there are two ways
> to get it by now: implement it by creating special database records to lock
> with SELECT FOR UPDATE or wait while they will be implemented in Postgres
> core. Is there something like predicate locking on the TODO list currently?

I assume you want ("real", as opposed to what is in < 9.1 now)
SERIALIZABLE transactions, in which case you could check:

<URL:http://wiki.postgresql.org/wiki/Serializable>

Nicolas


pgsql-hackers by date:

Previous
From: Vlad Arkhipov
Date:
Subject: Predicate locking
Next
From: Vlad Arkhipov
Date:
Subject: Re: Predicate locking