Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group