You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Something with the show_partition_info is grabbing the schema for the source table and trying to apply it to the target table as well. Likely because I'm using the parent_schemaname in both places
keith@github724=# call partman.partition_data_proc('pgmq.untitled', p_source_table := 'public.source_untitled', p_ignored_columns := ARRAY['msg_id']);
ERROR: Child table given does not exist (public.untitled_p20250103) for given parent table (pgmq.untitled)
CONTEXT: PL/pgSQL function partman.show_partition_info(text,text,text) line 37 at RAISE
SQL statement "SELECT child_start_time FROM partman.show_partition_info(v_source_schemaname||'.'||v_last_partition
, v_partition_interval::text
, p_parent_table)"
PL/pgSQL function partman.partition_data_time(text,integer,interval,numeric,text,boolean,text,text[]) line 153 at SQL statement
SQL statement "SELECT partman.partition_data_time (p_parent_table := 'pgmq.untitled', p_lock_wait := '0', p_order := 'ASC', p_analyze := false, p_source_table := 'public.source_untitled', p_ignored_columns := '{msg_id}')"
PL/pgSQL function partman.partition_data_proc(text,integer,text,integer,integer,integer,text,text,text[],boolean) line 86 at EXECUTE
Time: 12.464 ms
The text was updated successfully, but these errors were encountered:
Something with the
show_partition_info
is grabbing the schema for the source table and trying to apply it to the target table as well. Likely because I'm using the parent_schemaname in both placesThe text was updated successfully, but these errors were encountered: