Re: [SQL] raise doesn't add end of line

2008-11-17 Thread Sabin Coanda
Hi Pavel, I tried on Windows, and it works. Thanks a lot. BTW, I didn't succeed to find char(10) workaround because I tried at the end of the line, where ... it doesn't work. For instance check the function: -- Function: r() -- DROP FUNCTION r(); CREATE OR REPLACE FUNCTION r() RETURNS void

Re: [SQL] raise doesn't add end of line

2008-11-17 Thread Pavel Stehule
Hello it's true, and I thing, so it is a bug (please, report it). Workaround is simple. Use function chr. regards Pavel Stehule postgres=# create or replace function r() returns void as $$begin raise notice 'aa%naata%aa', chr(10),chr(10); end; $$ language plpgsql; CREATE FUNCTION postgres=# sele

Re: [SQL] raise doesn't add end of line

2008-11-17 Thread Sabin Coanda
Also I found all the characters E'\n' in a raise are filtered and not logged. I don't beleave no one knows how to log the end of line, maybe by a related configuration setting. Please help, or at least confirm there is a bug, to not waste time looking for workarounds. I'm disperate all my usefu

[SQL] raise doesn't add end of line

2008-11-14 Thread Sabin Coanda
Hi there, I upgrade "PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)" to "PostgreSQL 8.3.5, compiled by Visual C++ build 1400", and I found that many RAISE statements in a function no more adds end of line (CR/LF) on every message. Just when the funcion