using syslog to capture RAISE notices

Поиск
Список
Период
Сортировка
От Dan Langille
Тема using syslog to capture RAISE notices
Дата
Msg-id 20020311184952.832B13F0E@bast.unixathome.org
обсуждение исходный текст
Ответы Re: using syslog to capture RAISE notices  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
Can syslog be configured to capture RAISE messages?

Reading http://www.postgresql.org/idocs/index.php?plpgsql-
description.html#PLPGSQL-DESCRIPTION-ABORTING-AND-MESSAGES, I know how to
raise an exception, notice, or debug message.  But I've been unable to get
those messages logged via syslog.

I have this in syslog.conf:

*.debug;*.notice;kern.debug;lpr.info;mail.crit;news.err /var/log/messages

Here is the test routine I've used:

  DROP FUNCTION test();
CREATE FUNCTION test() returns int8 AS '
    BEGIN
    raise DEBUG \'this is dan raising a notice\';
        RETURN 1;
    END
' LANGUAGE 'plpgsql';

And the test:

fp2rifixed=# select test();
 test
------
    1
(1 row)

But nothing appears in /var/log/messages (yes, syslogd was HUP'd).

FWIW, this is PostgreSQL 7.2 under FreeBSD 4.5.
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples


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

Предыдущее
От: Eric Webber
Дата:
Сообщение: Re: [lxp-general] Re: FREE ERD TOOL for POSTGRES ???
Следующее
От: Frank_Lupo Frank_Lupo
Дата:
Сообщение: If possible create a table (not temp) for every user using equal name?