Re: pgsql --echo-errors --quiet and setval

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: pgsql --echo-errors --quiet and setval
Дата
Msg-id CAKFQuwbzKMJW4F2enc6rL4VP2o2bAj5v9EcfsoCTfXUZGtAPuw@mail.gmail.com
обсуждение исходный текст
Ответ на pgsql --echo-errors --quiet and setval  (Les <nagylzs@gmail.com>)
Ответы Re: pgsql --echo-errors --quiet and setval  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: pgsql --echo-errors --quiet and setval
Следующее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: postgreSQL UPPER Method is converting the character "µ" into "M"