From: Daniel Gustafsson <daniel@yesql.se>
To: Georgy Artos <georgyartos@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: [EXT]: Re: BUG #18604: Regression in PostgreSQL 16.4: pg_dump Prevents Essential System Table Modifications
Date: Tue, 4 Feb 2025 15:53:41 +0100
Message-ID: <5CDFBA04-DEBC-4BFD-BDC0-42CA1828AAD0@yesql.se> (raw)
In-Reply-To: <CAHZ8FghN_NOAZFnvdJXc4UB7F1AVLRJxB69D6AE3JCYDAEi24w@mail.gmail.com>
References: <CAHZ8FghN_NOAZFnvdJXc4UB7F1AVLRJxB69D6AE3JCYDAEi24w@mail.gmail.com>
> 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/p...
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: daniel@yesql.se, georgyartos@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: [EXT]: Re: BUG #18604: Regression in PostgreSQL 16.4: pg_dump Prevents Essential System Table Modifications
In-Reply-To: <5CDFBA04-DEBC-4BFD-BDC0-42CA1828AAD0@yesql.se>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox