maya.public

Parameters

Name	Type	Mode

Definition

DECLARE
            v_child_schemaname  text;
            v_child_table       text;
            v_child_tablename   text;
            v_upsert            text;
        BEGIN
             
        SELECT c.child_table, p.upsert INTO v_child_table, v_upsert
        FROM public.custom_time_partitions c
        JOIN public.part_config p ON c.parent_table = p.parent_table
        WHERE c.partition_range @> NEW.senddate 
        AND c.parent_table = 'public.event_ecm';
        SELECT schemaname, tablename INTO v_child_schemaname, v_child_tablename 
        FROM pg_catalog.pg_tables 
        WHERE schemaname = split_part(v_child_table, '.', 1)::name
        AND tablename = split_part(v_child_table, '.', 2)::name;
        IF v_child_schemaname IS NOT NULL AND v_child_tablename IS NOT NULL THEN
            EXECUTE format('INSERT INTO %I.%I VALUES ($1.*) %s', v_child_schemaname, v_child_tablename, v_upsert) USING NEW;
        ELSE
            RETURN NEW;
        END IF;
        RETURN NULL;
        END

event_ecm_part_trig_func()

Parameters

Definition