Is consistent (deterministic) ordering possible in our case?

Hi, Our story is as follows. We have a function called Foo() which internally will call many other sub-functions. These sub-functions have complicated if..else.. conditions. Calling function Foo() will start a transaction. Now the scenario is that when two processes call Foo() at the same time, th

Re: Is consistent (deterministic) ordering possible in our case?

where id < 10; > pg_try_advisory_lock > -- > t > t > t > t > t > t > t > t > t > (9 rows) > > > > On Wed, 2 Jun 2021 at 11:52, gerry gan wrote: > >> Hi, >> >> Our story is as follows. We have a fu