pgsql --echo-errors --quiet and setval

From: Les <nagylzs(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pgsql --echo-errors --quiet and setval
Date: 2023-09-08 19:36:11
Message-ID: CAKXe9UB-zH6Tn2hbvCON8n=twcOV02UskEvB3UGGs_+nD4fYOw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thank you,

Laszlo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2023-09-08 20:11:18 Re: pgsql --echo-errors --quiet and setval
Previous Message Adrian Klaver 2023-09-08 15:40:01 Re: pg_restore unexpected end of file