NESTED

Run inside a savepoint of the transaction already running, or start one where there is none.

A failure rolls back to the savepoint and leaves the surrounding transaction usable, which is what separates this from REQUIRED. It is still the same transaction and the same connection, so the outer one failing later still discards this work.