Re: simple_heap_update: tuple concurrently updated -- during INSERT - Mailing list pgsql-hackers

From Tom Lane
Subject Re: simple_heap_update: tuple concurrently updated -- during INSERT
Date
Msg-id 21336.1086794620@sss.pgh.pa.us
Whole thread Raw
In response to simple_heap_update: tuple concurrently updated -- during INSERT  ("SZŰCS Gábor" <surrano@mailbox.hu>)
List pgsql-hackers
"SZŰCS Gábor" <surrano@mailbox.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


pgsql-hackers by date:

Previous
From: Honza Pazdziora
Date:
Subject: Re: Improving postgresql.conf
Next
From: Bruce Momjian
Date:
Subject: Re: thread safety tests