Re: Tuple concurrency issue in large objects

2019-12-22 Thread Shalini
Well.. it seems I have to rethink about my application design. Anyway, thank you all for your insights and suggestions. On 12/18/2019 10:46 PM, Justin wrote: I agree  completely, I do not think Postgresql is a good fit for Shalini based on the conversation so far tracking Concurrency is

Re: Tuple concurrency issue in large objects

2019-12-17 Thread shalini
is no support for concurrent txns in pg_largeobject table?On 13-Dec-2019 5:25 PM, Daniel Verite wrote: Shalini wrote: > > Is there a workaround to this concurrency issue without creating a > > new   large object? The transaction failing with the "Tuple concurrentl

Re: Tuple concurrency issue in large objects

2019-12-10 Thread Shalini
Hi Rene, I am using Postgresql 11.2. Major version is 11 and minor version is 2. On 12/10/2019 11:24 AM, Rene Romero Benavides wrote: Hi Shalini. The usual diagnostic info is your postgresql server version, major and minor version, such as in 12.1 , the major version is 12 and the minor

Tuple concurrency issue in large objects

2019-12-06 Thread Shalini
_put(5810130, 10, '\xaa'); ERROR:  tuple concurrently updated Is there a workaround to this concurrency issue without creating a new large object? Regards Shalini