BUG #4536: raise doesn't add end of line

Поиск
Список
Период
Сортировка
От
Тема BUG #4536: raise doesn't add end of line
Дата
Msg-id 200811171523.mAHFNnF7090214@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4536: raise doesn't add end of line  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4536
Logged by:
Email address:      sabin.coanda@deuromedia.ro
PostgreSQL version: 8.3.5
Operating system:   Windows XP
Description:        raise doesn't add end of line
Details:

Many RAISE statements in a function no more
adds end of line (CR/LF) on every message, even if it contains chr(10)
explicitely. Just when the function ends, or inserting chr(10) in the middle
of the message a CR/LF is added in the log.

For instance consider the function:

CREATE OR REPLACE FUNCTION r()
  RETURNS void AS
$BODY$begin
raise notice 'Break the 1st%line...', chr(10);
raise notice 'eol on 2nd line...%', chr(10);
raise notice '3rd line';
raise notice '4th line';
end; $BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST 100;
ALTER FUNCTION r() OWNER TO postgres;

Run it:
    SELECT r()

And you get:

Run it:
    SELECT r()

And you get:

NOTICE:  Break the 1st
line...NOTICE:  eol on 2nd line...NOTICE:  3rd line

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

Предыдущее
От: "PRIME"
Дата:
Сообщение: BUG #4535: Foreign Key Constraints are not respected
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #4536: raise doesn't add end of line