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
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 |