CREATE OR REPLACE FUNCTION trigger_fct_tr_stg_application_cdim_ins()
RETURNS trigger
AS $$
declare
v_ErrorCode int;
v_ErrorMsg varchar(512);
v_Module varchar(32) := 'TR_STG_APPLICATION_CDIM_INS';
begin
if TG_OP = 'INSERT' then
if new.mig_filename IS NULL then
new.mig_filename := 'Unknown';
end if;
new.mig_insert_dt = current_timestamp;
end if;
RETURN NEW;
end;
$$
language plpgsql;
✓
hidden batch(es)
CREATE TRIGGER tr_stg_application_cdim_ins
BEFORE INSERT OR UPDATE ON stg_application_cdim
FOR EACH ROW EXECUTE PROCEDURE trigger_fct_tr_stg_application_cdim_ins();
✓
hidden batch(es)
insert into stg_application_cdim (id) values (42);
