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 24720.1086879787@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:
> The only thing I still don't understand is the "not in in-progress
> state" thing.

At the point where it's trying to send a NOTIFY, it's partially out
of its transaction --- the state has become TRANS_COMMIT instead of
TRANS_INPROGRESS.  Thus the warning.  It's no big deal.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Why frequently updated tables are an issue
Next
From: Josh Berkus
Date:
Subject: Re: Frequently updated tables