maya.public

Parameters

Name	Type	Mode
p_parent_table	text	IN
sub_partition_type	text	OUT
sub_control	text	OUT
sub_partition_interval	text	OUT
sub_constraint_cols	ARRAY	OUT
sub_premake	integer	OUT
sub_inherit_fk	boolean	OUT
sub_retention	text	OUT
sub_retention_schema	text	OUT
sub_retention_keep_table	boolean	OUT
sub_retention_keep_index	boolean	OUT
sub_automatic_maintenance	text	OUT
sub_epoch	text	OUT
sub_optimize_trigger	integer	OUT
sub_optimize_constraint	integer	OUT
sub_infinite_time_partitions	boolean	OUT
sub_jobmon	boolean	OUT
sub_trigger_exception_handling	boolean	OUT
sub_upsert	text	OUT
sub_trigger_return_null	boolean	OUT

Definition

/*
 * Check for consistent data in part_config_sub table. Was unable to get this working properly as either a constraint or trigger. 
 * Would either delay raising an error until the next write (which I cannot predict) or disallow future edits to update a sub-partition set's configuration.
 * This is called by run_maintainance() and at least provides a consistent way to check that I know will run. 
 * If anyone can get a working constraint/trigger, please help!
*/

WITH parent_info AS (
        SELECT c1.oid
        FROM pg_catalog.pg_class c1 
        JOIN pg_catalog.pg_namespace n1 ON c1.relnamespace = n1.oid
        WHERE n1.nspname = split_part(p_parent_table, '.', 1)::name
        AND c1.relname = split_part(p_parent_table, '.', 2)::name
    )
    , child_tables AS (
        SELECT n.nspname||'.'||c.relname AS tablename
        FROM pg_catalog.pg_inherits h
        JOIN pg_catalog.pg_class c ON c.oid = h.inhrelid
        JOIN pg_catalog.pg_namespace n ON c.relnamespace = n.oid
        JOIN parent_info pi ON h.inhparent = pi.oid
    )
    -- Column order here must match the RETURNS TABLE definition
    SELECT DISTINCT a.sub_partition_type
        , a.sub_control
        , a.sub_partition_interval
        , a.sub_constraint_cols
        , a.sub_premake
        , a.sub_inherit_fk
        , a.sub_retention
        , a.sub_retention_schema
        , a.sub_retention_keep_table
        , a.sub_retention_keep_index
        , a.sub_automatic_maintenance
        , a.sub_epoch
        , a.sub_optimize_trigger
        , a.sub_optimize_constraint
        , a.sub_infinite_time_partitions
        , a.sub_jobmon
        , a.sub_trigger_exception_handling
        , a.sub_upsert
        , a.sub_trigger_return_null
    FROM public.part_config_sub a
    JOIN child_tables b on a.sub_parent = b.tablename;

check_subpart_sameconfig(text)

Parameters

Definition