Re: BUG #18609: Repeated installcheck failure in test_pg_dump due to existing role - Mailing list pgsql-bugs

From Daniel Gustafsson
Subject Re: BUG #18609: Repeated installcheck failure in test_pg_dump due to existing role
Date
Msg-id 61043C0D-A79D-457A-AC2A-4719D036FBCD@yesql.se
Whole thread Raw
In response to BUG #18609: Repeated installcheck failure in test_pg_dump due to existing role  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
> 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




pgsql-bugs by date:

Previous
From: Muralikrishna Bandaru
Date:
Subject: Re: pl/perl extension fails on Windows
Next
From: Thomas Munro
Date:
Subject: Re: BUG #18610: llvm error: __aarch64_swp4_acq_rel which could not be resolved