---

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;