=>* 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_timeused to have a format call with 6 arguments, one was removed, but the reference to argument 4 and 6 was not updated:pg_partman/sql/functions/partition_data_time.sql
Lines 279 to 284 in a12b23e
pg_partman/sql/functions/partition_data_time.sql
Lines 216 to 222 in da0d708
1b9a24b#diff-75bc84e34ecbf5ac4f364b3031718978b08b556b0821256d72b796c638e76c11L216