Re: pg_upgrade test chatter

From: "Bossart, Nathan" <bossartn(at)amazon(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_upgrade test chatter
Date: 2021-10-19 20:20:44
Message-ID: 6389BAF2-02DA-414F-B643-585F66B47B85@amazon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 10/19/21, 12:37 PM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Actually ... why shouldn't we suppress that by running the command
> with client_min_messages = warning? This would have to be a change
> to pg_regress, but I'm having a hard time thinking of cases where
> quieting that message would be a problem.

I was just looking into something like this.

> We could dodge that, with modern versions of psql, by issuing
> two -c switches. So after a bit of hacking I have the attached
> POC patch. It's incomplete because now that we have this
> infrastructure we should change other parts of pg_regress
> to not launch psql N times where one would do. But it's enough
> to get through check-world without any chatter.
>
> Any objections to polishing this up and pushing it?

No objections here. This seems like an overall improvement, and I
confirmed that it clears up the NOTICE from the pg_upgrade test.

Nathan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2021-10-19 20:36:04 Re: ALTER INDEX .. RENAME allows to rename tables/views as well
Previous Message Mark Dilger 2021-10-19 20:17:56 Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers)