Re: Predicate locking

From: Nicolas Barbier <nicolas(dot)barbier(at)gmail(dot)com>
To: Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)ru>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Predicate locking
Date: 2011-04-27 08:45:58
Message-ID: BANLkTi=xd9H00DHvHfZZmvbrdXze=fqHnw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2011/4/27 Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vlad Arkhipov 2011-04-27 09:24:35 Re: Predicate locking
Previous Message Vlad Arkhipov 2011-04-27 08:35:01 Predicate locking