Re: "tuple concurrently updated" during index deletion - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: "tuple concurrently updated" during index deletion
Date
Msg-id 1184231049.4263.3.camel@ebony.site
Whole thread Raw
In response to "tuple concurrently updated" during index deletion  (Joe Conway <mail@joeconway.com>)
Responses Re: "tuple concurrently updated" during index deletion  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: [GENERAL] Count(*) throws error
Next
From: Hannu Krosing
Date:
Subject: Re: doubt