Re:PostgreSQL 11.3 and 10.8
by munk-a on Thursday May 09, 2019 @02:53PM
(#19871060)
Save points, with proper management of them, seem to match a conceptual nested transaction as far as I've seen. We've got a test bed connection manager that mocks savepoint creation, rollback and committal into transaction management functions so doing something like beginTransaction && beginTransaction works fine.
[ Parent
| on HN ]
Re:PostgreSQL 11.3 and 10.8
by atombender on Thursday May 09, 2019 @03:01PM
(#19871141)
There may be some semantic nuances. Savepoints aren't real transactions, so they "inherit" the locks of the parent transaction, for example. But it might not matter in practice in the context of tests.