From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: raise doesn't add end of line |
Date: | 2008-11-17 14:31:05 |
Message-ID: | 162867790811170631o2e409dd5ifb6734a91322450c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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=# select r();
NOTICE: aa
naata
aa
r
---
(1 row)
2008/11/17 Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)ro>:
> 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 usefull multiline logs are now useless
> :(
>
> TIA,
> Sabin
>
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sabin Coanda | 2008-11-17 15:01:44 | Re: raise doesn't add end of line |
Previous Message | Sabin Coanda | 2008-11-17 08:40:07 | Re: raise doesn't add end of line |