3 INSERT INTO config.upgrade_log (version) VALUES ('0393'); -- miker
5 CREATE OR REPLACE FUNCTION oils_i18n_update_apply(old_ident TEXT, new_ident TEXT, hint TEXT) RETURNS VOID AS $_$
9 UPDATE config.i18n_core
10 SET identity_value = $$ || new_ident || $$
11 WHERE fq_field LIKE '$$ || hint || $$.%'
12 AND identity_value = $$ || old_ident || $$;$$;
19 CREATE OR REPLACE FUNCTION oils_i18n_id_tracking(/* hint */) RETURNS TRIGGER AS $_$
21 PERFORM oils_i18n_update_apply( OLD.id::TEXT, NEW.id::TEXT, TG_ARGV[0]::TEXT );
26 CREATE OR REPLACE FUNCTION oils_i18n_code_tracking(/* hint */) RETURNS TRIGGER AS $_$
28 PERFORM oils_i18n_update_apply( OLD.code::TEXT, NEW.code::TEXT, TG_ARGV[0]::TEXT );
34 CREATE TRIGGER maintain_perm_i18n_tgr
35 AFTER UPDATE ON permission.perm_list
36 FOR EACH ROW EXECUTE PROCEDURE oils_i18n_id_tracking('ppl');