ontohub/ontohub — pull request #797 by 0robustus1 (2014-03-29 12:31:37+00:00)
Title: use savepoint for nested sql transaction

This may be able to fix the #576 issue.

We assume that the problem was related to the fact that
the failing cycle-checker would fail the transaction
(as true nested transactions are not supported by PostgreSQL)
and the next query (the logic_id check, or now the projects query)
is still executed as part of the transaction-block. However the
transaction does not exist anymore so the system fails.

However `requires_new: true` will add a savepoint. So
if the cycle-check (the content of the transaction-block)
fails, it will only rollback to the savepoint, but the
transaction will still exist.

----

This pretty much tells the whole story.
However it is quite hard, not to say **impossible** to test for this.