[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] RAISE NOTICE format in pgAdmin
From:       "Fernando Moreno" <azazel.7 () gmail ! com>
Date:       2008-08-30 4:01:11
Message-ID: b1c45530808292101i60ca3b22qa81c9e2563b49e8a () mail ! gmail ! com
[Download RAW message or body]

2008/8/29 Bill Todd <pg@dbginc.com>

> If I have a series of RAISE NOTICE 'xxx' statements in a plpgsql function
> and I call the function from pgAdmin the notice messages are concatenated on
> a single line on the Messages tab. Is there any way to get each message to
> appear on a separate line?
>
> Is there a better way than using RAISE NOTICE to debug functions?
>
> Bill
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

As far as I know, that is a known bug in the current version of pgAdmin, but
you can check the log file (directly or through the server status option)
for a more readable feedback.

[Attachment #3 (text/html)]

<div dir="ltr">2008/8/29 Bill Todd <span dir="ltr">&lt;<a \
href="mailto:pg@dbginc.com">pg@dbginc.com</a>&gt;</span><br><div \
class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid \
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> If I have a \
series of RAISE NOTICE &#39;xxx&#39; statements in a plpgsql function and I call the \
function from pgAdmin the notice messages are concatenated on a single line on the \
Messages tab. Is there any way to get each message to appear on a separate line?<br>

<br>
Is there a better way than using RAISE NOTICE to debug functions?<br>
<br>
Bill<br><font color="#888888">
<br>
-- <br>
Sent via pgsql-general mailing list (<a href="mailto:pgsql-general@postgresql.org" \
target="_blank">pgsql-general@postgresql.org</a>)<br> To make changes to your \
subscription:<br> <a href="http://www.postgresql.org/mailpref/pgsql-general" \
target="_blank">http://www.postgresql.org/mailpref/pgsql-general</a><br> \
</font></blockquote></div><br>As far as I know, that is a known bug in the current \
version of pgAdmin, but you can check the log file (directly or through the server \
status option) for a more readable feedback.<br></div>



[prev in list] [next in list] [prev in thread] [next in thread]