Re: Tuple concurrency issue in large objects

Поиск
Список
Период
Сортировка
От Daniel Verite
Тема Re: Tuple concurrency issue in large objects
Дата
Msg-id 6afceeda-e645-4892-8cd6-a5bd1fea54bd@manitou-mail.org
обсуждение исходный текст
Ответ на Re: Tuple concurrency issue in large objects  (Shalini <shalini@saralweb.com>)
Список pgsql-general
    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



В списке pgsql-general по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: How to Change collate & ctype for an existing database?
Следующее
От: İlyas Derse
Дата:
Сообщение: Is there an equivalent to sp_getapplock, sp_releaseapplock in PostgreSql?