From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: chenjq.jy@fujitsu.com
Subject: BUG #17148: About --no-strict-names option and --quiet option of pg_amcheck command
Date: Tue, 17 Aug 2021 04:34:28 +0000
Message-ID: <17148-b5087318e2b04fc6@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17148
Logged by: Chen Jiaoqian
Email address: chenjq.jy@fujitsu.com
PostgreSQL version: 14beta3
Operating system: Red Hat Enterprise Linux Server release 7.8
Description:
Hi, Author
In PG14 beta3, when I use pg_amcheck command, both --no-strict-names
option and --quiet option are specified, the warning message of --database
option is not suppressed.
The official website is described as follows:
> --no-strict-names
> By default, if an argument to --database, --table, --index, or
--relation matches no objects, it is a fatal error.
> This option downgrades that error to a warning. If this option is
used with --quiet, the warning will be suppressed as well.
When I specify a non-existent database name for the --database option,
and specify the --no-strict-names option and the --quiet option,
pg_amcheck command should not return any message, but it still returns
the warning message.
My steps are as follows:
1)Install the amcheck plguin in the PG source package
../contrib/amcheck directory;
2)In the postgres database, execute SQL "create extension
amcheck;"
3)On the OS command line, execute pg_amcheck command, specify
--no-strict-names option and --quiet option, and specify a non-existent
database name for the --database option
The result are as follows:
[postgres14@localhost ~]$ pg_amcheck -p 51403 -d postgres -d db01
--no-strict-names --quiet
pg_amcheck: warning: no connectable databases to check matching
"db01"
[postgres14@localhost ~]$
Regards.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, chenjq.jy@fujitsu.com
Subject: Re: BUG #17148: About --no-strict-names option and --quiet option of pg_amcheck command
In-Reply-To: <17148-b5087318e2b04fc6@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox