Re: Update concurrency

2021-12-20 Thread Tom Lane
[ please keep the list cc'd ] =?utf-8?Q?Sylvain_D=C3=A9ve?= writes: > Indeed I removed the important part here... I was including a function > definition ("create or replace function ...") in the call too. This was > temporary and dirty. After moving the definition of the function to the > ini

Re: Update concurrency

2021-12-20 Thread Tom Lane
=?utf-8?Q?Sylvain_D=C3=A9ve?= writes: > # JSONB update for a single selected row and column. > # 'column' and 'select_row' are determined with the parameters 'data' and > 'path'. > command = ( > f"""UPDATE MY_TABLE SET """ > f"""{column} = jsonb_merge({column}, %s) """

Re: Update concurrency

2021-12-20 Thread David G. Johnston
On Monday, December 20, 2021, Sylvain Déve wrote: > > To summarize, how can I allow for multiple updates of the same attributes, > one after another, even when these updates are requested almost at the same > time from independent, uncontrollable client requests? > Most people use an application

Update concurrency

2021-12-20 Thread Sylvain Déve
Hello, On a server, I have an API which is called by one or multiple clients. The server can receive, almost at the same time, multiple update instructions for the same PostgreSQL attribute. These requests do not arrive at the exact same time, and I would just like to execute them one after ano