ERROR: tuple concurrently updated

From: "Zubkovsky, Sergey" <Sergey(dot)Zubkovsky(at)transas(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: ERROR: tuple concurrently updated
Date: 2007-03-28 10:03:08
Message-ID: 528853D3C5ED2C4AA8990B504BA7FB850106DD94@sol.transas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello.

Testing of the concurrent access to database objects leaded to the following error:

 

  ERROR: tuple concurrently updated

  SQL state: XX000

 

According to the "PostgreSQL Error Codes" table in the documentation, "XX000" is the PostgreSQL internal error code.

 

How to reproduce such an error:

1. Create a table in some database and view:

create table t1 ( id int );

create temp view v1 as select * from t1;

2. Concurrent access to table t1 is performed by 2 clients (further C1 and C2) particularly in this order:

C1: begin; drop view v1;

C2: drop table t1;

C1: commit;

 

 And finally, transaction of the client C2 is terminated with this "expected" error.

 

What's wrong?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-03-28 18:02:19 Re: ERROR: tuple concurrently updated
Previous Message Magnus Hagander 2007-03-28 08:33:02 Re: "Permission denied" failures occurring on Windows