Re: BUG #18609: Repeated installcheck failure in test_pg_dump due to existing role

> On 11 Sep 2024, at 08:42, PG Bug reporting form <noreply@postgresql.org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference:      18609
> Logged by:          Nikita Kalinin
> Email address:      n.kalinin@postgrespro.ru
> PostgreSQL version: 16.4
> Operating system:   ubuntu 22.04
> Description:
>
> Hello!
> When running the installcheck a second time, the test_pg_dump fails due to
> the following reason:
> CREATE ROLE regress_dump_test_role;
> +ERROR:  role "regress_dump_test_role" already exists
> CREATE EXTENSION test_pg_dump;
>
> This issue is present from REL_12_STABLE to REL_16_STABLE. Maybe it's worth
> adding DROP ROLE regress_dump_test_role at the end of the test, like in
> REL_17_STABLE?

That would be backpatching 936e3fa3787a51397280c1081587586e83c20399.  I haven't
checked if there are complications in doing so but I think it should be quite
straightforward.

--
Daniel Gustafsson