> > >> SELECT client_code_increment INTO STRICT NEW.code FROM >> public.companies WHERE id = >> NEW.id ORDER BY client_code_increment DESC; >> > > > > I am pretty sure the above line is wrong. NEW.id refers to users.id, not > the companies.id. Also, the implementation presents a potential race > condition, e.g., if two different sessions attempt an insert almost > simultaneously.
I don't think so.. Even because if I change that to company_id, I get the error: ERROR: column "company_id" does not exist > > > > > END IF; >> IF (TG_OP = 'INSERT') THEN >> UPDATE public.companies SET client_code_increment = >> (client_code_increment + 1) WHERE >> id = NEW.id; >> > > > Ditto w.r.t. NEW.id. > >> >> Same as above
