[hcarvalhoalves]

It should be an atomic transaction, double-entry style, so it can’t fail between commas.

The important thing is not having money go missing.

[withinboredom]

The only way that is possible is if the tables exist on the same database server. Otherwise, you are right back at distributed transaction problems.

[hcarvalhoalves]

That's the whole point of double-entry. You don't split the entries.

[withinboredom]

Then this is off-topic af. We are talking about distributed systems here.