Re: Tuple concurrency issue in large objects

<div dir='auto'>Hi,<div dir="auto"><br></div><div dir="auto">Thanks. I will try this approach.</div><div dir="auto">Could you also please state the reason why is it happening in case of large objects? Because concurrent transactions are very well handled for other data types, but the same is not happening for lobs. Is it because the fomer are stored in toast table and there is no support for concurrent txns in pg_largeobject table?</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 13-Dec-2019 5:25 PM, Daniel Verite &lt;daniel(at)manitou-mail(dot)org&gt; wrote:<br type="attribution" /><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir="ltr">&#9;Shalini wrote:&#13;<br>
&#13;<br>
&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp; Is there a workaround to this concurrency issue without creating a&#13;<br>
&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp; new&nbsp;&nbsp; large object?&#13;<br>
&#13;<br>
The transaction failing with the "Tuple concurrently updated"&#13;<br>
error could be resubmitted by the client, as if it was a&#13;<br>
serialization failure.&#13;<br>
Or the failure could be prevented by using advisory locks:&#13;<br>
https://www.postgresql.org/docs/current/explicit-locking.html&#13;<br>
&#13;<br>
&#13;<br>
Best regards,&#13;<br>
-- &#13;<br>
Daniel V&#233;rit&#233;&#13;<br>
PostgreSQL-powered mailer: http://www.manitou-mail.org&#13;<br>
Twitter: @DanielVerite&#13;<br>
</p>
</blockquote></div><br></div>