Re: Tuple concurrency issue in large objects

"Daniel Verite" <[email protected]>
Newsgroups gmane.comp.db.postgresql.general
Message-ID <[email protected]>
	Shalini wrote:

> >     Is there a workaround to this concurrency issue without creating a
> >     new   large object?

The transaction failing with the "Tuple concurrently updated"
error could be resubmitted by the client, as if it was a
serialization failure.
Or the failure could be prevented by using advisory locks:
https://www.postgresql.org/docs/current/explicit-locking.html


Best regards,
-- 
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.