-- -- 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;