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?
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 |