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