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

Re: BUG #5989: Assertion failure on UPDATE of big value

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Marko Tiikkaja <marko(dot)tiikkaja(at)2ndquadrant(dot)com>, pgsql-bugs(at)postgresql(dot)org, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Subject: Re: BUG #5989: Assertion failure on UPDATE of big value
Date: 2011-04-20 15:03:30
Message-ID: 4DAEF5C2.3040508@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 20.04.2011 17:51, Tom Lane wrote:
> ... which means that the first transaction is completed and
> can no longer be holding any locks.

Predicate locks are held after transaction commit. They can only be 
cleaned once the xid is older than the oldest xmin among all active 
serializable transactions.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

In response to

pgsql-bugs by date

Next:From: Kevin GrittnerDate: 2011-04-20 15:08:07
Subject: Re: BUG #5989: Assertion failure on UPDATE of big value
Previous:From: Heikki LinnakangasDate: 2011-04-20 14:59:32
Subject: Re: BUG #5989: Assertion failure on UPDATE of big value

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