Re: pgsql --echo-errors --quiet and setval - Mailing list pgsql-general

From David G. Johnston
Subject Re: pgsql --echo-errors --quiet and setval
Date
Msg-id CAKFQuwbzKMJW4F2enc6rL4VP2o2bAj5v9EcfsoCTfXUZGtAPuw@mail.gmail.com
Whole thread Raw
In response to pgsql --echo-errors --quiet and setval  (Les <nagylzs@gmail.com>)
Responses Re: pgsql --echo-errors --quiet and setval
List pgsql-general
On Fri, Sep 8, 2023 at 1:41 PM Les <nagylzs@gmail.com> wrote:

  Dear fellow PostgreSQL users,

Today I caught this with postgresql v15, while restoring a database with psql  --echo-errors --quiet. (The dump was made using pg_dump -Fp).

It logged lots of these messages:

 setval
--------
   1001
(1 row)

In other words, it logs **some** things that are not errors, even though --quiet was specified. Is this the expected behaviour? I would argue that with --quiet --echo-errors, only errors should be logged, and setting the value of a sequence is not an error.

The output of SELECT queries cannot be quieted, only redirected.

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pgsql --echo-errors --quiet and setval
Next
From: "Peter J. Holzer"
Date:
Subject: Re: postgreSQL UPPER Method is converting the character "µ" into "M"