> On 4 Feb 2025, at 15:43, Georgy Artos <georgyartos@gmail.com> wrote:
> Post Scriptum: There's a non-namespaced/schematized query at [4],
> however I guess it's really just me not understanding the pg_dump
> code...
> [4]
https://github.com/postgres/postgres/blob/53a49365052026907afff7613929710d1e7f0da0/src/bin/pg_dump/pg_dump.c#L1723C18-L1723C32
Thanks for the report, any such query should be fixed. In this case it seems
fine, partition_tree is set up as a recursive common table expression a few
lines earlier in the function:
if (with_child_tables)
{
appendPQExpBuffer(query, "WITH RECURSIVE partition_tree (relid) AS (\n");
}
--
Daniel Gustafsson