View Single Post

   
  #4 (permalink)  
Old 04-15-2008, 08:58 PM
Simon Riggs
 
Posts: n/a
Default Re: "tuple concurrently updated" during index deletion

On Wed, 2007-07-11 at 16:49 -0700, Joe Conway wrote:
> On cvs head, I can get "tuple concurrently updated" if two separate
> transactions are both trying to drop the same index:


> ERROR: tuple concurrently updated


> The reason I ask is that someone contacted me who is seeing this on a
> production system, and the abort on session #2 is rolling back a large
> bulkload.


This situation will always cause an error on session #2, since if you
lock this more closely you'll get an ERROR because the object does not
exist.

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Reply With Quote