Re: Simple client messages from within pgPL/SQL

From: "Andre Schnoor" <andre(dot)schnoor(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Simple client messages from within pgPL/SQL
Date: 2005-02-23 10:00:11
Message-ID: 3832drF5k8qfkU1@individual.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I'm desparately seeking for a simple way to send messages to the client
> during the execution of large stored procedures.
>
> RAISE INFO 'Now Processing %', thisCustomer;
>
> Doesn't do it, because the client console is cluttered with verbose
context
> information (e.g. backtrace). It's impossible to follow these "messages".
>
> I'm afraid that lowering the verbosity level in the server config will
also
> affect error messages (where verbosity is helpful). Is there another way
to
> output strings to the "console"?

Example:

INFO: Total of 25130 listed songs found, 13046 of them did not perform
today
CONTEXT: SQL statement "SELECT sp_song_performance_reset( $1 )"
PL/pgSQL function "sp_song_performance_batch" line 41 at select into
variables
SQL statement "SELECT sp_song_performance_batch( $1 )"
PL/pgSQL function "sp_daily" line 39 at select into variables
SQL statement "SELECT sp_daily()"
PL/pgSQL function "sp_test_charts" line 14 at select into variables

I only want to have the first line appear and nothing else.
How do I suppress the CONTEXT clutter?

Andre

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Terry Lee Tucker 2005-02-23 10:12:30 Re: Simple client messages from within pgPL/SQL
Previous Message Michael Fuhr 2005-02-23 08:42:23 Re: tsearch2 problems / limitations