Re: RAISE NOTICE format in pgAdmin

From: "Fernando Moreno" <azazel(dot)7(at)gmail(dot)com>
To: "Bill Todd" <pg(at)dbginc(dot)com>
Cc: "PgSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: RAISE NOTICE format in pgAdmin
Date: 2008-08-30 04:01:11
Message-ID: b1c45530808292101i60ca3b22qa81c9e2563b49e8a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2008/8/29 Bill Todd <pg(at)dbginc(dot)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(at)postgresql(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albretch Mueller 2008-08-30 11:47:28 DUPS in tables columns ERROR: column ". . . " does not exist
Previous Message Tom Lane 2008-08-30 03:16:32 Re: SELECT INTO returns incorrect values