---

BEGIN;

LOCK TABLE back_office.operation_type
    IN SHARE ROW EXCLUSIVE MODE;

SELECT
    MAX(id) AS max_id,
    MAX(id) + 1 AS next_id
FROM back_office.operation_type;