Home > mailing lists

DELETE ERROR: tuple concurrently updated - Mailing list pgsql-general

From	Михаил Кечинов
Subject	DELETE ERROR: tuple concurrently updated
Date	December 29, 2009 09:08:55
Msg-id	c8f0e27c0912290141k44f8d947l34cf7c48b984af98@mail.gmail.com Whole thread Raw
Responses	Re: DELETE ERROR: tuple concurrently updated (Greg Stark <gsstark@mit.edu>) Re: DELETE ERROR: tuple concurrently updated (Greg Stark <gsstark@mit.edu>)
List	pgsql-general

Hello.

Here is a problem, which I can't understand.

One week ago our database has crashed and after restore begins some problems.

One of them:

When I try to delete one row from database (for example):

delete from document where numdoc = 901721617

I have this error:

ERROR: tuple concurrently updated

SQL state: XX000

I know, that no one deleting this row at same time.

What's mean this error?

Thanks.

From: John R Pierce
Date: 29 December 2009, 03:23:20
Subject: Re: Installation of Postgis/postgresql

From: Greg Stark
Date: 29 December 2009, 09:52:11
Subject: Re: DELETE ERROR: tuple concurrently updated