Re: How to hide NOTICE messages in psql.exe ?

Поиск
Список
Период
Сортировка
От Richard Broersma Jr
Тема Re: How to hide NOTICE messages in psql.exe ?
Дата
Msg-id 20060706180215.1075.qmail@web31809.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Re: How to hide NOTICE messages in psql.exe ?  ("Szymic1" <dyrex@poczta.onet.pl>)
Список pgsql-general
> > might also be interested in psql's -q option (or "\set QUIET").
>
> I use -q but I've got e.g
>
> Z:\>psql.exe -q -d ff -h localhost -p 5432 -U postgres
> 0<D:\ff\centralny\src\db\processing_utils.sql
> NOTICE:  type reference ff.alias.mask%TYPE converted to character
> varying
> NOTICE:  type reference freeconet.logic_list_item.conv%TYPE converted
> to charact
> er varying
> NOTICE:  type reference ff.logic_list_item.conv%TYPE converted to
> charact
> er varying
> NOTICE:  type reference ff.alias.mask%TYPE converted to character
> varying
> NOTICE:  type reference ff.account.user_name%TYPE converted to
> character
> varying
> NOTICE:  type reference ff.alias.mask%TYPE converted to character
> varying
>
> I would like to hide lines with NOTICE


Would making the following changes to you postgresql.conf help?

redirect_stderr = true
client_min_messages = warning

You may need to restart PostgreSQL for these changes to take effect.

Regards,
Richard Broersma Jr.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Szymic1"
Дата:
Сообщение: Re: How to hide NOTICE messages in psql.exe ?
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Backing up the currently used wal segment