Re: BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION - Mailing list pgsql-bugs

From Laurenz Albe
Subject Re: BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION
Date
Msg-id 9ad3c3781f8d89efab1917d1431226f4da79d443.camel@cybertec.at
Whole thread Raw
In response to BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION
List 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
> https://www.postgresql.org/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



pgsql-bugs by date:

Previous
From: David Rowley
Date:
Subject: Re: Issue with pg_get_functiondef
Next
From: Laurenz Albe
Date:
Subject: Re: Issue with pg_get_functiondef