Postgres Pro
Downloads
Home   >   mailing lists

Thread: RAISE NOTICE format in pgAdmin

RAISE NOTICE format in pgAdmin

From
Bill Todd
Date:
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

Re: RAISE NOTICE format in pgAdmin

From
"Fernando Moreno"
Date:
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.

Re: RAISE NOTICE format in pgAdmin

From
Tony Caduto
Date:
Bill Todd wrote:
> 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
>
Bill,
Make sure you are on at least version 8.2 (8.3 is preferred) and use a
plpgsql debugger.  Later versions of Pgadmin have one built in and a
stand alone version is available from:
http://www.amsoftwaredesign.com/debugger_client_announce  (built with
Delphi)

If you are using the win32 version there is a option at the end of the
installer script to install the debugger part.  On 8.2 or 8.3 you will
need to install it yourself.
Please see: http://pgfoundry.org/projects/edb-debugger/

Hope that helps.

Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of Lightning Admin for PostgreSQL