Re: simple_heap_update: tuple concurrently updated -- during INSERT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: SZŰCS Gábor <surrano(at)mailbox(dot)hu>
Cc: "PGH" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: simple_heap_update: tuple concurrently updated -- during INSERT
Date: 2004-06-09 15:23:40
Message-ID: 21336.1086794620@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" <surrano(at)mailbox(dot)hu> writes:
> ERROR: simple_heap_update: tuple concurrently updatedog.
> LOG: statement: INSERT INTO pakolas_cikktetel
> (cikk, minoseg, helyrol, mennyi, pakolas, sorszam, helyre) VALUES
> (102165, 1, 1488, '25', 68615, 1, 1338)

Hmm. AFAIK, an INSERT statement per se will never call
simple_heap_update at all --- that routine is only used for system
catalog updates. I'm wondering what is going on behind the scenes
here. Have you got any triggers or rules that this INSERT would
fire, and if so what do they do? Maybe you are using NOTIFY?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Honza Pazdziora 2004-06-09 15:26:44 Re: Improving postgresql.conf
Previous Message pgsql 2004-06-09 15:18:36 Re: Frequently updated tables