From: Tom Lane <tgl@sss.pgh.pa.us>
To: Aksel Allas <allasaksel@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION
Date: Tue, 12 Dec 2023 10:09:35 -0500
Message-ID: <2436651.1702393775@sss.pgh.pa.us> (raw)
In-Reply-To: <CABnLe_AtD_M66oYkzgzxTe2fyi7rUwLZb1oU7Ug1y5jv==SKTQ@mail.gmail.com>
References: <18242-89f57a188c7de6c8@postgresql.org>
<9ad3c3781f8d89efab1917d1431226f4da79d443.camel@cybertec.at>
<CABnLe_AtD_M66oYkzgzxTe2fyi7rUwLZb1oU7Ug1y5jv==SKTQ@mail.gmail.com>
Aksel Allas <allasaksel@gmail.com> writes:
> So it's not possible to fully use pg_dump without manually altering the
> output of pg_dump in managed postgreSQL cases?
Nope, trying to dump/restore other people's objects as a non-superuser
isn't considered supported at the moment. You're not the first to
complain about this, but no coherent proposal to improve it has been
made. It's not very clear what the supported case ought to be
exactly; clearly a zero-privilege user can't succeed at this, but what
privileges should be expected? Also it's not clear what problems
exist beyond the schema-privilege one, and it's not clear how we could
solve the problem(s) without creating other ones. There's a lot of
history behind the way that pg_dump does things, so rearranging its
choices about how/when to change privileges is scary.
regards, tom lane
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: tgl@sss.pgh.pa.us, allasaksel@gmail.com, laurenz.albe@cybertec.at, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION
In-Reply-To: <2436651.1702393775@sss.pgh.pa.us>
* 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