From: | "" <sabin(dot)coanda(at)deuromedia(dot)ro> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4536: raise doesn't add end of line |
Date: | 2008-11-17 15:23:49 |
Message-ID: | 200811171523.mAHFNnF7090214@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4536
Logged by:
Email address: sabin(dot)coanda(at)deuromedia(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-11-17 19:56:21 | Re: BUG #4536: raise doesn't add end of line |
Previous Message | PRIME | 2008-11-17 14:37:43 | BUG #4535: Foreign Key Constraints are not respected |