Re: Silencing NOTICEs in Perl Pg

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Silencing NOTICEs in Perl Pg
Дата
Msg-id 200208300050.g7U0oKp11272@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Silencing NOTICEs in Perl Pg  (David Wheeler <david@wheeler.net>)
Ответы Re: Silencing NOTICEs in Perl Pg  (David Wheeler <david@wheeler.net>)
Список pgsql-admin
7.3 will have client_min_message, which if set to WARNING will note show
notices.  7.3 is due out in a few months, beta starts next week.

---------------------------------------------------------------------------

David Wheeler wrote:
> On Thursday, August 29, 2002, at 01:02  PM, Bruno Wolff III wrote:
>
> > On Thu, Aug 29, 2002 at 12:17:16 -0700,
> >   David Wheeler <david@wheeler.net> wrote:
> >> BTW, I missed the beginning of this thread, but based on the subject,
> >> I'd sure like to find out if there's a simple way to suppress NOTICEs
> >> using DBI/DBD::Pg. I've tried a number of tricks, but short of closing
> >> STDOUT and STDERR in my Perl script, I've not found a way to do it.
> >> PrintError => 0 doesn't do the trick.
> >
> > I do the following before doing anything with the database:
> > open(OLDERR, '>&STDERR');
> > close(STDERR);
> > open(STDERR, '>/dev/null');
>
> Thanks for the suggestion. Unfortunately, that doesn't allow me to
> filter out just the NOTICEs, and let everything else be printed. The
> solution I've come up with, for those who are interested, is either
> this:
>
> open STDERR, "| perl -e 'while (<>) { print unless /^NOTICE:  / }'"
>    or die "Cannot pipe STDERR: $!\n";
>
> Or this:
>
> open STDERR, "| grep -v '^NOTICE:  '"
>    or die "Cannot pipe STDERR to grep\n";
>
> The former will be more portable, since we already know we have Perl ;-)
>
> Thanks for the help!
>
> David
>
> --
> David Wheeler                                     AIM: dwTheory
> david@wheeler.net                                 ICQ: 15726394
> http://david.wheeler.net/                      Yahoo!: dew7e
>                                                 Jabber: Theory@jabber.org
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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

Предыдущее
От: David Wheeler
Дата:
Сообщение: Re: Silencing NOTICEs in Perl Pg
Следующее
От: David Wheeler
Дата:
Сообщение: Re: Silencing NOTICEs in Perl Pg