--
-- category_synonym__new_cat_trans_trg/0
--
create or replace function category_synonym__new_cat_trans_trg(
  
) returns trigger as $$

-- trigger function for inserting category translation
declare
    v_synonym_id     integer;
begin
	-- create synonym
    v_synonym_id := category_synonym__new (NEW.name, NEW.locale, NEW.category_id, null);

	-- mark synonym as not editable for users
    update category_synonyms
    set synonym_p = 'f'
    where synonym_id = v_synonym_id;

    return new;
end;$$ language plpgsql;