tuple concurrently updated

Поиск
Список
Период
Сортировка
От Andrus
Тема tuple concurrently updated
Дата
Msg-id f1cql5$27pf$1@news.hub.org
обсуждение исходный текст
Ответы Re: tuple concurrently updated  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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;
 $$;


В списке pgsql-general по дате отправления:

Предыдущее
От: pumesh
Дата:
Сообщение: script for taking incremental backup in postgres in LINUX
Следующее
От: "Jan Bilek"
Дата:
Сообщение: Re: Password authentication failed