| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | aksel(dot)allas(at)pactum(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION |
| Date: | 2023-12-12 12:14:33 |
| Message-ID: | 9ad3c3781f8d89efab1917d1431226f4da79d443.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, 2023-12-12 at 10:43 +0000, PG Bug reporting form wrote:
> When making a dump from PostgreSQL 14 and using it in PostgreSQL 15 with a
> user that has no superuser access (e.g. cloud environments), then we run
> into the following line from
> /docs/15/sql-alterfunction.html
>
> > To alter the owner, you must also be a direct or indirect member of the
> new owning role, and that role must have CREATE privilege on the function's
> schema.
That is working as it should.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2023-12-12 12:18:49 | Re: Issue with pg_get_functiondef |
| Previous Message | David Rowley | 2023-12-12 12:14:24 | Re: Issue with pg_get_functiondef |