-- -- category_synonym__edit_cat_trans_trg/0 -- create or replace function category_synonym__edit_cat_trans_trg( ) returns trigger as $$ -- trigger function for updating a category translation declare v_synonym_id integer; begin -- get synonym_id of updated category translation select synonym_id into v_synonym_id from category_synonyms where category_id = OLD.category_id and name = OLD.name and locale = OLD.locale and synonym_p = 'f'; -- update synonym PERFORM category_synonym__edit (v_synonym_id, NEW.name, NEW.locale); return new; end;$$ language plpgsql;