What about a `DEFERRABLE INITIALLY DEFERRED` trigger that increments a sequence only on commit?