tuple concurrently updated

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: tuple concurrently updated
Date: 2007-05-03 14:12:43
Message-ID: f1cql5$27pf$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My application receives the folllowing error sometimes.

Any idea how to fix ?

Andrus.

7/XX000:Error while executing the query;ERROR: tuple concurrently updated

CONTEXT: SQL statement "DROP TABLE templsabi"PL/pgSQL function "drop_table"
line 2 at execute statement

SELECT drop_table('templsabi');CREATE TABLE templsabi AS
select
toode,
osak as sihtyksus,
partii,
laosumma,

1 as lj, 0 as st, 0 as vm,
0 as kaubasumma,
kogus,
0 as kogpak,
CAST('' AS CHAR(10)) as yksus,
CAST('' AS CHAR(1)) as doktyyp
from HETKESEI
where true
AND osak LIKE 'TARTU%' ESCAPE '!'

AND toode='DIS123103'
;SELECT * FROM templsabi

drop_table is defined as

CREATE OR REPLACE FUNCTION drop_table(TEXT)
RETURNS VOID STRICT LANGUAGE plpgsql AS $$
BEGIN
EXECUTE 'DROP TABLE ' || $1;
EXCEPTION WHEN UNDEFINED_TABLE THEN
RETURN;
END;
$$;

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-05-03 14:43:28 Re: psql access of user's environmental variables
Previous Message Csaba Nagy 2007-05-03 14:06:52 Re: Update violating constraint