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;
$$;
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 |