Skip to content

Invalid format call in partition_data_time #862

@vdl-dsi-architecture

Description

@vdl-dsi-architecture
=>* CALL partman.partition_data_proc(
    p_parent_table := 'public.trace',
    p_interval := '6 months',
    p_wait := 0,
    p_lock_wait := 10,
    p_source_table := 'public.trace_old'
);
ERREUR:  trop peu d'arguments pour format()
CONTEXT:  affectation PL/pgSQL « v_sql := format('SELECT * FROM ONLY %I.%I WHERE %s >= %L AND %4$s < %6$L FOR UPDATE NOWAIT'
                    , v_source_schemaname
                    , v_source_tablename
                    , v_partition_expression
                    , v_min_partition_timestamp
                    , v_max_partition_timestamp) »
fonction PL/pgSQL partition_data_time(text,integer,interval,numeric,text,boolean,text,text[],boolean,boolean), ligne 264 à affectation
instruction SQL « SELECT partman.partition_data_time (p_parent_table := 'public.trace'
                                                , p_lock_wait := '10'
                                                , p_order := 'ASC'
                                                , p_analyze := false, p_batch_interval := '6 months', p_source_table := 'public.trace_old', p_ignore_infinity := 'f') »
fonction PL/pgSQL partman.partition_data_proc(text,integer,text,integer,integer,integer,text,text,text[],boolean,boolean), ligne 92 à EXECUTE
Time: 79.869 ms

It looks like partition_data_time used to have a format call with 6 arguments, one was removed, but the reference to argument 4 and 6 was not updated:

v_sql := format('SELECT * FROM ONLY %I.%I WHERE %s >= %L AND %4$s < %6$L FOR UPDATE NOWAIT'
, v_source_schemaname
, v_source_tablename
, v_partition_expression
, v_min_partition_timestamp
, v_max_partition_timestamp);

EXECUTE format('SELECT %s FROM ONLY %I.%I WHERE %s >= %L AND %4$s < %6$L FOR UPDATE NOWAIT'
, v_column_list
, v_source_schemaname
, v_source_tablename
, v_partition_expression
, v_min_partition_timestamp
, v_max_partition_timestamp);

1b9a24b#diff-75bc84e34ecbf5ac4f364b3031718978b08b556b0821256d72b796c638e76c11L216

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions