Hey Nick,
Thanks! Yep that’s an alternative (together with a uniqueness constraint
and retry mechanism)
I guess what I’m trying to get my head around is whether and why this would
be better than using advisory locks…
Cheers
Perryn
On Thu, 14 Apr 2022 at 10:32 pm, Nick Cleaton wrote:
> On Thu,
what happens if
> the insert into the ledger fails. If you haven't already, maybe check out
> the 'saga' pattern.
>
> Cheers,
>
> Steve
>
> On Thu, Apr 14, 2022 at 5:11 PM Perryn Fowler wrote:
>
>> Hi there,
>>
>> We have identified a prob
Hi there,
We have identified a problem that we think advisory locks could help with,
but we wanted to get some advice on whether its a good idea to use them
this way (and any tips, best practices or gotchas we should know about)
THE PROBLEM
We have some code that does the following
- For
