Typical DB’s utilize BEGIN TRANSACTION to ensure multiple table updates required to complete a “transaction” complete entirely. If the entire set of DB writes do not complete it allows for ROLLBACK, which restores all the tables affected hence guaranteeing referential integrity.
It seems Bubble does not support this even though PostgreSQL includes this functionality.
Am I missing something? If I am correct I suggest this is a significant flaw in Bubble’s DB functional architecture. If wrong, could someone please show me where to find this or how to activate it.