Just an update here:
IF (TG_OP = 'INSERT') THEN
UPDATE public.companies SET client_code_increment = (client_code_increment + 1) WHERE id = NEW.company_id;
The line above was updating the client_code_increment even if the customer was inserting data by hiimself, which is wrong.
The client_code_increment must be updated IF is an insert AND if the customer did not insert data into the code column.
Correction:
IF (TG_OP = 'INSERT') AND NEW.code IS NULL THEN
UPDATE public.companies SET client_code_increment = (client_code_increment + 1) WHERE id = NEW.company_id;
Cheers
Lucas
