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